Hi All,
I can start mysql with the following cmd,
/etc/rc.d/init.d/mysql start
although, I had to change
bindir=./bin
to
bindir=/usr/local/mysql/bin
to get it to work. I can access the DB with,
mysql -h localhost -u root -p
successfully, but, when trying to access via phpmyadmin or webmin it doesn't work. I've set the config files to what I believe are correct.
phpmyadmin error below,
Error
*MySQL said: *Documentation <http://dev.mysql.com/doc/mysql/en/Error-returns.html>
| #2002 - Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
I've got user as root and no password, as I haven't set 1 yet. Why am I getting this.? Anyone seen this before.?
With webmin, I get this displayed,
|*MySQL is not running on your system - database list could not be retrieved.
*Click this button to start the MySQL database server on your system with the command /etc/rc.d/init.d/mysql start. This Webmin module cannot administer the database until it is started.
even though the server is running, confirmed with the following,
root@localhost ~]# ps -uxwww | grep mysql
Warning: bad syntax, perhaps a bogus '-'? See /usr/share/doc/procps-3.2.3/FAQ
root 4640 0.0 0.2 4180 1116 ? S 14:19 0:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/localhost.localdomain.pid
root 4771 0.0 0.0 1580 124 pts/2 R+ 14:36 0:00 grep mysql
Is anyone on here running webmin to manage mysql..? I'm curious how you got it to run..? If I stop the server via cli and then click the start mysql server button on the webmin page, it goes back to the same message, but, the server is started. I changed the config module page to reflect my installation. What have I missed, perhaps..? Cheers.
below is the config of webmin mysql module,
*Path to mysqlshow command* /usr/bin/mysqlshow
*Path to mysqladmin command* /usr/local/mysql/bin/mysqladmin
*Path to mysql command* /usr/local/mysql/bin/mysql
*Path to mysqldump command* /usr/local/mysql/bin/mysqldump
*Path to mysqlimport command* /usr/local/mysql/bin/mysqlimport
*Command to start MySQL server* /etc/rc.d/init.d/mysql start
*Command to stop MySQL server* /etc/rc.d/init.d/mysql stop
*Path to MySQL shared libraries directory* *Path to MySQL databases directory* /var/lib/mysql
Mark Sargent.
