Is this a php app you are using? Or did you create the php script? If the later, can you post the code?
On Fri, 2003-05-30 at 21:02, Daniel Kuecker wrote: > yes i did. i cant actually connect to the database from a remote PC using > mysql control center app i got from mysql website. it is just this darn php > script not allowing me to... > > ----- Original Message ----- > From: "Adam J" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, May 30, 2003 8:50 PM > Subject: Re: [sclug-general] mysql > > > > Did you create the user wic in your mysql database? > > If you need to do that, you can check out this page: > > http://www.mysql.com/doc/en/Adding_users.html > > > > Hope this helps! > > Adam > > > > > > On Fri, 2003-05-30 at 20:31, Daniel Kuecker wrote: > > > 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 > > > > > > > > > > > > > > > > > > > >
