mysql安装与配置

注意：整个安装在root用户下

1.添加用户及用户组：

• useradd mysql
• passwd mysql
• groupadd mysql
• gpasswd -a mysql mysql

2.下载MySQL：wget http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.33-linux-glibc2.5-x86_64.tar.gz

3.解压：

tar -zxvf mysql-5.6.33-linux-glibc2.5-x86_64.tar.gz -C /usr/local/

mv mysql-5.6.40-linux-glibc2.12-x86_64 mysql

4.创建目录：mkdir /usr/local/mysql/data/mysql

   修改mysql目录所有者和所属组：chown -R mysql:mysql mysql

5.执行安装

  ./scripts/mysql_install_db --user=mysql --datadir=/usr/local/mysql/data/mysql

  cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld

  chmod 755 /etc/init.d/mysqld

  cp /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf

6.修改配置文件

•  vi /etc/init.d/mysqld
•   basedir=/usr/local/mysql/
•  datadir=/usr/local/mysql/data/mysql

7. #启动mysql
  service mysqld start
  #关闭mysql
  service mysqld stop
  #查看运行状态
  service mysqld status

8.登录MySQL

mysql -u root -p  (第一次登录无密码)

9.其他

update user set password=password('password01') where user='root' and host='zhangbk';
FLUSH PRIVILEGES;  --修改完密码，必须执行这一句。

mysql> create database zabbix character set utf8 collate utf8_bin;
mysql> create user 'zabbix'@'%' identified by '123';
mysql> grant all privileges on zabbix.* to 'zabbix'@'%';

若密码忘记，登录不了，vi /etc/my.conf添加skip-grant-tables，然后重启mysql，输入mysql进入mysql库，对密码update即可。

修改完之后，将/etc/my.conf改回来。

找不到MySQL库：查看user表中root用户的localhost权限：select * from user where user='root' and host='localhost'
在显示的列表中显示：root用户的localhost的权限都是'N',表示root用户本地登陆不具有权限
修改root用户的localhost权限：
  update user set  
  `Select_priv` = 'Y',
  `Insert_priv` = 'Y',
  `Update_priv` = 'Y',
  `Delete_priv` = 'Y',
  `Create_priv` = 'Y',
  `Drop_priv` = 'Y',
  `Reload_priv` = 'Y',
  `Shutdown_priv` = 'Y',
  `Process_priv` = 'Y',
  `File_priv` = 'Y',
  `Grant_priv` = 'Y',
  `References_priv` = 'Y',
  `Index_priv` = 'Y',
  `Alter_priv` = 'Y',
  `Show_db_priv` = 'Y',
  `Super_priv` = 'Y',
  `Create_tmp_table_priv` = 'Y',
  `Lock_tables_priv` = 'Y',
  `Execute_priv` = 'Y',
  `Repl_slave_priv` = 'Y',
  `Repl_client_priv` = 'Y',
  `Create_view_priv` = 'Y',
  `Show_view_priv` = 'Y',
  `Create_routine_priv` = 'Y',
  `Alter_routine_priv` = 'Y',
  `Create_user_priv` = 'Y',
  `Event_priv` = 'Y',
  `Trigger_priv` = 'Y',
  `Create_tablespace_priv` = 'Y'
  where user='root' and host='localhost
  更新一下：flush privileges;