mysql快乐教程_快乐编程

1.rpm -qa|grep -i mysql

2.

service mysql stop

/etc/init.d/mysql shutdown

service mysqld stop

/etc/init.d/mysqld shutdown

3.rpm -ev MySQL-client-5.5.25a-1.rhel5

rpm -e –nodeps MySQL-server-5.5.25a-1.rhel5 (-nodeps强制删)

4.find / -name mysql

rm -rf /var/lib/mysql

rm -rf /usr/lib64/mysql 等

rm -rf /etc/my.cnf

5.rpm -qa|grep -i mysql

6.yum list | grep mysql

7.yum install mysql

8.yum install mysql-server

9.rpm -qi mysql-server

10./etc/init.d/mysqld start 等

11.mysql [-uroot -p]

12.select user();

13.show grants for root@localhost;

14.update user set password=password(’123′) where user=’root’;

15.FLUSH PRIVILEGES;

16.GRANT ALL PRIVILEGES ON db.* TO ‘user_name’@'%’ IDENTIFIED BY ‘abc’ WITH GRANT OPTION;