On 12/5/02 at 18:40, [EMAIL PROTECTED] (Phil Dobbin) wrote: > I got finally got it started by doing: > > su mysql > password xxxxxx > mysql% cd /usr/local/mysql > mysql% ./bin/safe_mysqld --user=mysql > > but now I get 1045 error messages when I try to access mysql whether > as me or root: > > [localhost:~] phil% mysqladmin reload > .../bin/mysqladmin: connect to server at 'localhost' failed > error: 'Access denied for user: 'phil@localhost' (Using password: > YES)' > [localhost:~] phil% mysqladmin -u root -p create database_name > Enter password: > .../bin/mysqladmin: connect to server at 'localhost' failed > error: 'Access denied for user: 'root@localhost' (Using password: > YES)' > [localhost:~] phil%
Well, I finally got in but now I get a 1044 error: [localhost:~] phil% mysql -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 37 to server version: 3.23.49-entropy.ch Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> create database CONTACT; ERROR 1044: Access denied for user: '@localhost' to database 'CONTACT' mysql> Any thoughts on this one? Basically I need to access the user tables but it will not let me any further than here. Regards, Phil. --------------------------------------------------------------------- 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