2 messages in com.mysql.lists.plusplusRe: Access denied for user: 'root@loc...
FromSent OnAttachments
Rohan Shrivastava07 Jun 2004 05:57 
Joseph Burneff07 Jun 2004 12:41 
Subject:Re: Access denied for user: 'root@localhost' to database 'msyql'
From:Joseph Burneff (jpbu@yahoo.com)
Date:06/07/2004 12:41:39 PM
List:com.mysql.lists.plusplus

Rohon,

Have you set a password for the root user? I think you need to do this prior to logging on as root. Try the following:

mysqladmin -u root -password 'yourpassword'

This should set the root user password for mysql and allow you to log on.

Joe --- Rohan Shrivastava <roha@iiita.ac.in> wrote:

Hello!!!,

How can i can make entry in users table for "root" user.

Actually i am unable to connect to the mysql server by root user.

It delivers an error message

Access denied for user: 'root@localhost' to database 'msyql'

when i issues command >> mysql -u root msyql

To remove this error i tried to restart mysqld with -Sg option, but it goes in var directory in /usr/local/mysql-3.23.58-pc-linux-i686/ which does not exist.

What could be the problem for this? also How can do this by using Mysqlcc?

Thanks in Advance

Regards

Rohan

-- MySQL++ Mailing List For list archives: http://lists.mysql.com/plusplus To unsubscribe:

334-728-0964