yum在线安装mysql

mysql
 
 --查看系统之前是否已安装MySQL
        rpm -qa | grep mysql
        
--有的话，卸载
        rpm -e mysql-libs-5.1.73-5.el6_6.x86_64 --nodeps
        
 yum install mysql mysql-server mysql-devel


完成后，用  /etc/init.d/mysqld start    启动mysql


启动mysql控制台：
      mysql
mysql>USE mysql;
mysql>UPDATE user SET Password=PASSWORD('123') WHERE user='root';
mysql>FLUSH PRIVILEGES;
     允许远程登录
mysql -u root -p
Enter Password: <your new password>
mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123' WITH GRANT OPTION;
mysql>FLUSH PRIVILEGES;
    完成后就能远程管理mysql了。

   mysql服务名字   service  mysqld start
   
   
   GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123' WITH GRANT OPTION;

 UPDATE user SET Password=PASSWORD('hadoop') WHERE user='root';

设置为开机自启
 chkconfig mysqld on
chkconfig mysqld --list