[root@localhost ~]# yum -y install mysql-server

Installed: mysql-server.x86_64 0:5.1.73-7.el6                        Dependency Installed: mysql.x86_64 0:5.1.73-7.el6         perl-DBD-MySQL.x86_64 0:4.013-3.el6        Complete!

[root@localhost ~]# chkconfig mysqld on

[root@localhost ~]# service mysqld start

[root@localhost ~]# service mysqld stop

[root@localhost ~]# service mysqld restart

[root@stonex ~]# mysql -u rootmysql> set password for root@localhost=password('root');mysql> exit

[mysqld]datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sockuser=mysql#最重要的下面這一行代碼skip-grant-tables# Disabling symbolic-links is recommended to prevent assorted security riskssymbolic-links=0[mysqld_safe]log-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pid

[root@localhost ~]# service mysqld restart

 [root@localhost ~]# mysql -u root mysql> use mysql; mysql> set password for root@localhost=password('root'); mysql> flush privileges; mysql> exit; [root@localhost ~]# service mysqld restart

[mysqld]datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sockuser=mysql# Disabling symbolic-links is recommended to prevent assorted security riskssymbolic-links=0[mysqld_safe]log-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pid

[root@localhost ~]# mysql -u root -p

show databases; //查看系統(tǒng)已存在的數(shù)據(jù)庫use databasesname;  //選擇需要使用的數(shù)據(jù)庫drop database databasename; //刪除選定的數(shù)據(jù)庫exit  //退出數(shù)據(jù)庫的連接create database test01;  //建立名為test的數(shù)據(jù)庫show tables;    // 列出當(dāng)前數(shù)據(jù)庫下的表其他基本的增刪改查使用標(biāo)準(zhǔn)SQL即可

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;FLUSH PRIVILEGES;