linux下安装mysql

# yum -y install http://dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm
# yum info mysql-community-server
# yum -y install mysql-community-server
# vi /etc/my.cnf
    character-set-server=utf8
# /etc/init.d/mysqld restart
# mysqld --version
    mysqld  Ver 5.6.23 for Linux on x86_64 (MySQL Community Server (GPL))

# mysql_secure_installation  
    Enter current password for root (enter for none):　←　回车  
  
    Set root password? [Y/n]　←　回车  
    New password:　←　123456  
    Re-enter new password:　←　123456  
  
    Remove anonymous users? [Y/n]　←　回车(删除匿名用户)  
  
    Disallow root login remotely? [Y/n]　←　回车(禁止远程root登录)  
  
    Remove test database and access to it? [Y/n]　←　回车(删除test库)  
  
    Reload privilege tables now? [Y/n]　←　回车  
  
    Thanks for using MySQL!  
# mysql -u root -p  
    Enter password:123456  
  
    mysql> create database mydb;  
    mysql> grant all privileges on mydb.* to testuser@localhost identified by '123456';  
    mysql> select user, host from mysql.user;  
    mysql> quit