Hi shawn, You have probably have % in the user and host of the user table, so mysql client let you in without a username. To be able to use mysql database, you have to login as the root user. Just type, mysql -u root -p and see if you can login in that way. Besides, you have to restart mysqld from your unix shell prompt, you can't do it inside the mysql client .. I hope this helps, Gurhan ----- Original Message ----- From: "Page Works Web Solutions" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, June 30, 2002 3:14 AM Subject: Root pass
> Hi all, > Yet another 3am night and I still can't get my MySql to work. I > installed MySql on a cobalt Raq 4 server running Linux. I can telnet into > the mysql directory, but can not seem to change the root pass. I've > searched every place except the one that as the answer to my question. What > am I doing wrong. Below is the session if you can help. > > > > [admin admin]$ mysql > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 16 to server version: 3.23.37 > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer > > mysql> show databases > -> ; > +----------+ > | Database | > +----------+ > | mysql | > | test | > +----------+ > 2 rows in set (0.00 sec) > > mysql> use test; > Database changed > mysql> use mysql; > ERROR 1044: Access denied for user: '@localhost' to database 'mysql' > mysql> bin/mysqld -Skip-grant > -> USE mysql; > ERROR 1064: You have an error in your SQL syntax near > 'bin/mysqld -Skip-grant > USE mysql' at line 1 > > > > Thanks in advance for any help. :) > Shawn > > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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