mysql database question!

nabil · 01-21-2002, 07:11 PM

Hello.

I have a web server running php with mysql databse on a Sun Solaris 8 Intel machine and would like to convert this box into a RedHat linux machine.

I went and setup the Redhat machine exactly like the Sun one and then copied over the mysql database for my application hoping it will work but it did not and it kept complaining about user id's and password ?????
Any ideas !!
Is it possible for this to happen ???

Thanks in advance

lfslinux · 01-21-2002, 07:13 PM

Quote:

Originally posted by nabil
Hello.

I have a web server running php with mysql databse on a Sun Solaris 8 Intel machine and would like to convert this box into a RedHat linux machine.

I went and setup the Redhat machine exactly like the Sun one and then copied over the mysql database for my application hoping it will work but it did not and it kept complaining about user id's and password ?????
Any ideas !!
Is it possible for this to happen ???

Thanks in advance

Did you just copy the database for the website, or did you copy all of mysql? Mysql has a master database usually called 'mysql' that contains the mysql users/passwords and what mysql user has what kind of access to which databases.

nabil · 01-22-2002, 04:20 PM

I only copied the databse,...
I will try to go and copy mysql dir too to see if that will work,.
I think this is what you are suggesting for me to do ...

nabil · 01-22-2002, 05:00 PM

Thanks that did it.

I am now able to run my old database on my new server...

Thanks again.