RE: Newbie's question - Manuel Arroyo-Kalin - 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:	Manuel Arroyo-Kalin (maa...@cam.ac.uk)
Date:	10/27/2004 02:36:38 PM
List:	com.mysql.lists.win32

Thank you Robert and Paulo, this seesm to do the trick. Onto the next bit... I am working with an external application (IGDB - see http://www.pirrotte.lu/igdb/) that runs on Java and is based around Mysql. However, now I am getting this from the application:

SQL Exception :Invalid authorization specification, message from server: "Access denied for user: 'root@localhost' (Using password: YES)"

despite the fact that I have set a paasword for root, and used it...

I don't get it

m. On Wed, 27 Oct 2004, Urcid Pliego, Paulo wrote:

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

-----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?

-- MySQL Windows Mailing List For list archives: http://lists.mysql.com/win32 To unsubscribe: http://lists.mysql.com/win32?unsub=urc...@vw.com.mx

On Wed, 27 Oct 2004, Nurse, Robert (Cont, ARL/CISD) wrote:

There's post installation documentation (very brief) you should look at: http://dev.mysql.com/doc/mysql/en/Default_privileges.html.

I'm a newbie too and I ran into this same thing. Also, you have to use:

mysql -u root

There's no password on this (super) user initially. That's why you should go through this procedure as soon as you've installed it. Access is denied because there is no user called '@localhost'. When you log in as root, you should then be able to perform that query. root@localhost exits.

Robert Nurse STG Contractor - Applications Development Enterprise Management Center Computational & Information Sciences Directorate

-----Original Message----- From: Manuel Arroyo-Kalin [mailto:maa...@hermes.cam.ac.uk] On Behalf Of Manuel Arroyo-Kalin Sent: Wednesday, October 27, 2004 3:44 PM To: win...@lists.mysql.com Subject: Newbie's question