XK8ER
asked on
mysql setup
hello there,
I installed the same version of mysql yesterday on my server and today im trying to do the same thing for a server running on Centos v5.6
whats the issue here because its a fresh install but its not letting me set a password or start it..
I installed the same version of mysql yesterday on my server and today im trying to do the same thing for a server running on Centos v5.6
whats the issue here because its a fresh install but its not letting me set a password or start it..
[(08:04 PM)][(root@alpha)] [(~)] $ /opt/mysql5158/bin/mysqladmin version
/opt/mysql5158/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'
[(08:04 PM)][(root@alpha)] [(~)] $ /opt/mysql5158/bin/mysqladmin -u root password 'temp123'
/opt/mysql5158/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'
[(08:04 PM)][(root@alpha)] [(~)] $ /opt/mysql5158/bin/mysqladmin --defaults-file=/opt/mysql5158/etc/my.cnf shutdown
[(08:04 PM)][(root@alpha)] [(~)] $ /opt/mysql5158/etc/mysql.server start
Starting MySQL.Manager of pid-file quit without updating fi[FAILED]
[(08:04 PM)][(root@alpha)] [(~)] $
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
okay, I found the problem.. all i had to do was remove the /etc/my.cnf
/etc/my.cnf is usually where teh configuration file is usually located, you could link
ln -s /opt/mysql5158/etc/my.cnf /etc/my.cnf
ln -s /opt/mysql5158/etc/my.cnf /etc/my.cnf
ASKER
/opt/mysql5158/bin/mysqld_
I was able to login with phpmyadmin and import the database and the website is able to communicate..
when I shutdown the running safe mode mysql and try to start it like this
/opt/mysql5158/etc/mysql.s
this is what I get
Open in new window