RE: Newbie's question - Urcid Pliego, Paulo - com.mysql.lists.win32

7 messages in com.mysql.lists.win32RE: Newbie's question

From	Sent On	Attachments
Manuel Arroyo-Kalin	27 Oct 2004 12:43
Urcid Pliego, Paulo	27 Oct 2004 13:08
Nurse, Robert (Cont, ARL/CISD)	27 Oct 2004 13:08
Manuel Arroyo-Kalin	27 Oct 2004 14:36
Leigh Sharpe	27 Oct 2004 15:58
Manuel Arroyo-Kalin	28 Oct 2004 03:17
Manuel Arroyo-Kalin	02 Nov 2004 05:31

Subject:	RE: Newbie's question
From:	Urcid Pliego, Paulo (paul...@vw.com.mx)
Date:	10/27/2004 01:08:10 PM
List:	com.mysql.lists.win32

Manuel,

It looks to me like you need to start MySQL as root user (C:\mysql\bin>mysql -u root). It is recommended that the first thing you do when starting mysql is to change the root password, and create custom user accounts with the GRANT command (check the manual for that one).

Good luck

Paulo

-----Original Message----- From: Manuel Arroyo-Kalin [mailto:maa...@cam.ac.uk] Sent: Miercoles, 27 de Octubre de 2004 02:44 p.m. To: win...@lists.mysql.com Subject: Newbie's question

Hello,

This is my first post to the list and also my first attempt to install mySql - so far failing miserably on a standalone computer win WIN XP PRO:

winmysqladmin.exe starts at Startup, with a traffic light icon in the systray

if I open a cmd window and then, in mysql, try to create a database (presumably the first thing to do):

C:\mysql\bin>mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version: 4.0.21-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> CREATE DATABASE 1sttest; ERROR 1044: Access denied for user: '@localhost' to database '1sttest' mysql>

Now, what's the next step?