shangyhi2000
asked on
how to change the data directory for nysql
hi all,
i have a situation where i need to change the data root for mysql to another directory
can you please help me to do so
thanks in advance
shangyhi2000
i have a situation where i need to change the data root for mysql to another directory
can you please help me to do so
thanks in advance
shangyhi2000
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Strange, I wouldnt have thought phpmyadmin needed access to the db files...
Does mysql start ok after the move?
Can you login locally?
What error do you get when phpmyadmin starts?
Does mysql start ok after the move?
Can you login locally?
What error do you get when phpmyadmin starts?
ASKER
Does mysql start ok after the move? yes
Can you login locally? no
What error do you get when phpmyadmin starts?can't access db
Can you login locally? no
What error do you get when phpmyadmin starts?can't access db
are you using the correct user credentials and is the login you are using configured to allow access from the host you are coming from?
ASKER
jools,
can you please explain more what is your question
can you please explain more what is your question
ASKER
i'm using centos 5.4 the configuration file is /etc/my.cnf
after i do so mysql service restart normally but phpmyadmin does not work i don't know why i've installed it using yum
can you help in that