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

Reply via email to