Friday, May 22, 2009
In my server webmin was installed but mysql was not there. The server was running centos5.3.
After some googling i found some solutions and here is the combination which might solve your problems.
You have to have access to a shell window in the server. You can access using putty or
by loggin into your webmin, go to Others->Command Shell.You can type commands in this shell.
If using putty, you will get the command shell any way :) after logging in.
Inorder to check if mysql is already installed or not run this command
which mysql
If found it will show some directory name otherwise not found
In order to remove old mysql
yum remove mysql-server
yum remove mysql
Now to install mysql run this command from the shell or a command line access point
yum install mysql-server
yum install mysql
yum install mysql-devel
Inorder to use with php
yum install php-mysql
By default mysql has the no passward. To change the password in command shell write the following commands
mysql
mysql> USE mysql;
mysql> UPDATE user SET Password=PASSWORD('new-password') WHERE user='root';
mysql> FLUSH PRIVILEGES;
That's all, if anything is missing let me know
Labels: CentOs 5.3, MySql, WebMin