Try mysql -u root mysql -p
* * Cal Evans * The Virtual CIO * http://www.calevans.com * -----Original Message----- From: Page Works Web Solutions [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 02, 2002 11:02 PM To: MySql mailing list (E-mail) Subject: root passwords Hi all, MySql on linux box, I did the following and now I'm stuck. [admin admin]$ su -l Password: ***************************************************************** * * * NOTICE TO ROOT USER: Changes to system files may affect * * your warranty. Please consult your warranty card for details. * * * * http://www.cobalt.com * * * ***************************************************************** [root /root]# ps -aux |grep mysql root 29177 0.0 0.1 1364 504 pts/0 R 00:03 0:00 grep mysql [root /root]# whereis scripts/mysql_install_db mysql_install_db: /usr/bin/mysql_install_db [root /root]# /usr/bin/mysql_install_db Installing all prepared tables 020703 0:07:50 /usr/sbin/mysqld: Shutdown Complete To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: /usr/bin/mysqladmin -u root -p password 'new-password' /usr/bin/mysqladmin -u root -h www.pageworksyour.com -p password 'new-password' See the manual for more instructions. NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be able to use the new GRANT command! You can start the MySQL daemon with: cd / ; /usr/bin/safe_mysqld & You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: cd sql-bench ; run-all-tests Please report any problems with the /usr/bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at https://order.mysql.com [root /root]# /usr/bin/mysqladmin -u root -p password testpassword Enter password: /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql .sock' (111)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' ex ists! [root /root]# whereis mysql mysql: /usr/bin/mysql /usr/lib/mysql /usr/include/mysql /usr/share/mysql /usr/ma n/man1/mysql.1.gz [root /root]# /usr/bin/mysql ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/m ysql.sock' (111) [root /root]# cd / ; /usr/bin/safe_mysqld & [1] 29482 [root /]# Starting mysqld daemon with databases from /var/lib/mysql [root /]# ps -aux |grep mysql mysql 29500 0.0 0.5 11548 1364 pts/0 S 00:11 0:00 /usr/sbin/mysqld mysql 29502 0.0 0.5 11548 1364 pts/0 S 00:11 0:00 /usr/sbin/mysqld mysql 29503 0.0 0.5 11548 1364 pts/0 S 00:11 0:00 /usr/sbin/mysqld root 29624 0.0 0.1 1364 512 pts/0 S 00:14 0:00 grep mysql [root /]# mysql -u root mysql ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) [root /]# is this something easy that I'm missing? 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