Hi Not sure here, but you have logged in as 'admin' on the system. Unless you su to root mysql will use the same user.
try either [admin admin]$ su -l to log in to the system as root and then 'mysql -p' to log into mysql or stay as admin but log into mysql as root, under mysql [admin admin]$ mysql -u root -p The clue is in the line ERROR 1044: Access denied for user: '@localhost' to database 'mysql' which would read 'root@localhost' if you were logged in as root HTH, if not come back to me Peter ----------------------------------------------- Excellence in internet and open source software ----------------------------------------------- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 ----------------------------------------------- > -----Original Message----- > From: Page Works Web Solutions [mailto:[EMAIL PROTECTED]] > Sent: 30 June 2002 08:14 > To: [EMAIL PROTECTED] > 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
