Linux下安装MySQL

来源：互联网发布：人机界面编程编辑：程序博客网时间：2024/05/17 03:28

首先到官网下载MySQL的源码包

由于家里网速不好，等了好久才在官网上找到tar.gz包。不能不吐槽下这网络，选择version和platform的JS都失效，只能上阿里云通过curl来找到。

wget http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.21-linux-glibc2.5-x86_64.tar.gz

首先，先查看当前系统是否已安装过MySQL

#rpm -a代表all，-q代表query[root@iZ283rmolcfZ download]# rpm -aq | grep -i mysqlmysql-libs-5.1.73-3.el6_5.x86_64#卸载mysql[root@iZ283rmolcfZ download]# yum -y remove mysql-libs*

1.增加用户mysql（系统用户）

#-M不创建home目录,-s指定shell为不登录useradd -M -s /bin/nologin mysql

2.开始安装

#解压mysql-5.6.21-linux-glibc2.5-x86_64.tar.gztar -zxvf mysql-5.6.21-linux-glibc2.5-x86_64.tar.gz#将解压的文件复制到安装路径/usr/local/mysqlcp -r mysql-5.6.21 /usr/local/mysqcd /usr/local/mysqcp  support-files/my-default.cnf  /etc/my.cnfchmod 644 /etc/my.cnf#修改my.cnfvim /etc/my.cnfuser=mysqldatadir=/data/mysql#创建/data/mysqlmkdir -p /data/mysqlchwon -R mysql:mysql /data/mysql#初始化数据库scripts/mysql_install_db --initialize留意最后1行，root账号的初始密码2017-02-21T13:49:42.616172Z 1 [Note] A temporary password is generated for root@localhost: -8s<iMutfDy<#启动MySQLscripts/mysql_install_db 或者 service mysql start

3.设置开机自动启动

cd /usr/local/mysql/support-files#注册服务cp mysql.server /etc/rc.d/init.d/mysql#让chkconfig管理mysql服务chkconfig --add mysql#开机启动chkconfig mysql on

4.修改MySQL的root密码

#由于没有设置密码，直接使用命令mysql就可以登录mysqluse mysql#将User为空的用户加上用户名update user set User='xxx' where User='';#设置root的密码update user set Password=password('xxxxx') where User='root';#刷新权限flush privileges;#或者使用下面这句SQLGRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '******' WITH GRANT OPTION;mysql修改报错：ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement解决：alter user 'root'@'localhost' identified by 'root';

0 0