1. Yum install mysql-server mysql php-mysql
2. To start and stop the service following command:
service mysqld start or /etc/init.d/mysqld start
service mysqld stop or /etc/init.d/mysqld stop
3. Login to Mysql:
mysql -u root
4. To set root user password for all local domains login to MySql and run the below queries as required:
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('new-password');
SET PASSWORD FOR 'root'@'localhost.localdomain' = PASSWORD('new-password');
SET PASSWORD FOR 'root'@'127.0.0.1' = PASSWORD('new-password');
5. To drop any user use the below queris in MySql prompt:
DROP USER ''@'localhost';
DROP USER ''@'localhost.localdomain';
6. For exiting from MySql type "exit".
2. To start and stop the service following command:
service mysqld start or /etc/init.d/mysqld start
service mysqld stop or /etc/init.d/mysqld stop
3. Login to Mysql:
mysql -u root
4. To set root user password for all local domains login to MySql and run the below queries as required:
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('new-password');
SET PASSWORD FOR 'root'@'localhost.localdomain' = PASSWORD('new-password');
SET PASSWORD FOR 'root'@'127.0.0.1' = PASSWORD('new-password');
5. To drop any user use the below queris in MySql prompt:
DROP USER ''@'localhost';
DROP USER ''@'localhost.localdomain';
6. For exiting from MySql type "exit".
No comments:
Post a Comment