Pages

Wednesday 6 February 2013

Installing and configuring MySql Using Yum.

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".

No comments:

Post a Comment