thanks, I finally got it. i am able to connect with the mysql console app for windows, but i downloaded a php app that still says:
MySQL server said: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) i thought i read somewhere that php and mysql use different encryption algorythms, so i dont know what to do now... daniel ----- Original Message ----- From: "Adam J" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, May 30, 2003 8:22 PM Subject: Re: [sclug-general] mysql > 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 > >
