Try
mysql -u root -p
Or just restart mysql with --skip-grant-tables
and see what is up...!
Simon
-----Original Message-----
From: Neil Barnes [mailto:[EMAIL PROTECTED]]
Sent: 11 July 2001 15:19
To: [EMAIL PROTECTED]
Subject: Cannot Login as ROOT
Hi everyone.
Please see below, I cannot login as the root user in MySQL. Access-Denied
... any ideas anyone?
My System = RedHat Linux 7.0 (all latest patches applied) Intel Pentium
III
MySQL rpm's installed =
MySQL-3.23.39-1.i386.rpm
MySQL-client-3.23.39-1.i386.rpm
MySQL-shared-3.23.39-1.i386.rpm
Installed OK no problem.
I ran mysql_install_db no problem.
Now try to install new root password...as per documentation....
[root@mail mysql]# mysqladmin -password FalsePass
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: YES)'
root@mail mysql]# ps -ef | grep mysql
root 22558 1 0 13:22 pts/0 00:00:00 sh /usr/bin/safe_mysqld
--datadi
mysql 22581 22558 0 13:22 pts/0 00:00:00 /usr/sbin/mysqld
--basedir=/ --d
mysql 22583 22581 0 13:22 pts/0 00:00:00 /usr/sbin/mysqld
--basedir=/ --d
mysql 22584 22583 0 13:22 pts/0 00:00:00 /usr/sbin/mysqld
--basedir=/ --d
root 22707 22686 0 13:34 pts/1 00:00:00 su - mysql
mysql 22708 22707 0 13:34 pts/1 00:00:00 -bash
root 22852 22112 0 14:14 pts/0 00:00:00 grep mysql
[root@mail mysql]#
root@mail mysql]# mysql
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
Regards
Neil Barnes, Systems Manager
DCA Liner Limited
4 Pennine Way,
Saltley Business Park,
Saltley,
Birmingham B8 1JW
T: +44 121 325 7527
F: +44 121 328 2552
E: [EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
