There is one important thing to note. The system root is not associated with the mysql root. Thus to start out, the mysql root user has no password. You can login using the following:
mysql -u root To assign it a password, you can do this: mysqladmin -u root password 'password' If that doesnt work, you may need to do the following: Try doing the following: 1. su into the box 2. groupadd mysql 3. useradd -g mysql mysql 4. chown -R root /usr/local/mysql 5. chown -R mysql /usr/local/mysql 6. chown -R mysql /usr/local/mysql/data Now you should be able to start the server (if it is not already) with: bin/safe_mysqld --user=mysql & good luck! Adam On Fri, 2003-05-30 at 19:23, Daniel Kuecker wrote: > hey all. > i have RH9 loaded fesh, along with > mysql and php. i am trying, but when i try to connect to the database, > it says > > [WIC] ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using > password: YES) > > any ideas? i cannot seem to get connect. i can connect ehrn i ssh into > the server and use mysqladmin -u root -p > > please help! > > Thanks > daniel
