php学建网站,厦门建设局刘以汉,网站建设私人接单,展览网站模板一、卸载mysql安装有三种方式#xff0c;包括二进制包安装(Using Generic Binaries)、RPM包安装、源码安装。一般是前两种比较多二、安装建议路径设置按照写的来将下载的压缩包复制到linux服务器/usr/local/路径下(下载地址https://dev.mysql.com/downloads/mysql/,进去下载默…一、卸载mysql安装有三种方式包括二进制包安装(Using Generic Binaries)、RPM包安装、源码安装。一般是前两种比较多二、安装建议路径设置按照写的来将下载的压缩包复制到linux服务器/usr/local/路径下(下载地址https://dev.mysql.com/downloads/mysql/,进去下载默认是最新的找到Looking for previous GA versions?点击就可以找到以前的版本Linux-Generic是通用版的意思)1、进入压缩包存放目录[rootlocalhost ~]# cd /usr/local2、解压压缩包[rootlocalhost local]# tar -xzvf mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz3、修改文件夹名字将解压后的文件夹修改名字文件夹名字改为mysql4、检查并创建用户和用户组[rootlocalhost local]# cat /etc/group | grep mysql[rootlocalhost local]# cat /etc/passwd |grep mysql[rootlocalhost local]# groupadd mysql[rootlocalhost local]# useradd -r -g mysql mysql5、创建data文件夹某个版本之后就没有data文件夹了[rootlocalhost local]mkdir /usr/local/mysql/data6、授权目录和用户(****重要****)忘记授权会出问题em...各种各样的问题[rootlocalhost /]# cd /usr/local/[rootlocalhost local]# chown -R mysql:mysql mysql/[rootlocalhost local]# chmod -R 755 mysql/7、安装并初始化(*****重要******)执行下面之前去/etc/目录下查看是否有my.cnf配置文件如果有删除或者修改名字备份起来不然会出现各种PID或者SOCK有关的问题某个版本之后这个步骤是下面这样以前是mysql_install_dbdatadir就是安装路径basedir就是根目录[rootlocalhost local]# /usr/local/mysql/bin/mysqld --initialize --usermysql --datadir/usr/local/mysql/data --basedir/usr/local/mysql执行完上面之后检查是否有Error有的话及时解决。[rootlocalhost local]# /usr/local/mysql/bin/mysqld --initialize --usermysql --datadir/usr/local/mysql/data --basedir/usr/local/mysql2019-07-18T07:38:20.300936Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).2019-07-18T07:38:21.037889Z 0 [Warning] InnoDB: New log files created, LSN457902019-07-18T07:38:21.124063Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.2019-07-18T07:38:21.194242Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been start ed. Generating a new UUID: 0448b7a0-a92f-11e9-ac91-fa163e17d701.2019-07-18T07:38:21.195622Z 0 [Warning] Gtid table is not ready to be used. Table mysql.gtid_executed cannot be opened.2019-07-18T07:38:21.196412Z 1 [Note] A temporary password is generated for rootlocalhost: n2ta1yWih9-/最后一行会有默认生成的密码记下来A temporary password is generated for rootlocalhost: n2ta1yWih9-/8、复制启动脚本到资源目录[rootlocalhost local]# cd mysql[rootlocalhost mysql]# cp ./support-files/mysql.server /etc/rc.d/init.d/mysqld提示是否覆盖的话可能之前装过没删除输入y覆盖9、增加mysqld服务控制脚本执行权限[rootlocalhost mysql]# chmod x /etc/rc.d/init.d/mysqld10、将mysqld服务加入到系统服务[rootlocalhost mysql]# chkconfig --add mysqld11、检查mysqld服务是否已经生效[rootlocalhost mysql]# chkconfig --list mysqldmysqld 0:关闭 1:关闭 2:启用 3:启用 4:启用 5:启用 6:关闭12、启动mysql[rootlocalhost mysql]# service mysqld start显示SUCCESS的话到这里就已经启动成功了12-2、启动mysql失败提示找不到mysql命令的话[rootlocalhost mysql]# ln -s /usr/local/mysql/bin/mysql /usr/bin13、登录mysql失败的话看下面[rootlocalhost mysql]# service mysqld startStarting MySQL.2019-07-18T07:41:24.268830Z mysqld_safe Directory /var/lib/mysql for UNIX socket file dont exists.The server quit without updating PID file (/var/lib/mysql/z[失败]pid).[rootlocalhost mysql]# mkdir /var/lib/mysql[rootlocalhost mysql]# service mysqld startStarting MySQL.The server quit without updating PID file (/[失败]b/mysql/localhost.pid).[rootlocalhost mysql]# mysql -uroot -pEnter password:ERROR 2002 (HY000): Cant connect to local MySQL server through socket /tmp/mysql.sock (2)13-2、登录mysql失败失败信息ERROR 2002 (HY000): Cant connect to local MySQL server through socket /tmp/mysql.sock (2)[rootlocalhost mysql]# ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock然后返回13步重新执行14、(在mysql命令行模式下)修改密码下面最后面的root就是密码修改完之后退出重新登录一次试试有些在修改密码的时候执行下面的会报错可以参考https://blog.csdn.net/q258523454/article/details/84555847或者百度一下很容易解决mysql flush privileges;mysql ALTER USER rootlocalhost IDENTIFIED BY root;mysql flush privileges;mysql quit[rootlocalhost mysql]# mysql -uroot -p15、配置3306端口开启防火墙(如果以前已经安装过mysql的这个一般都已经设置好了我的是新建的虚拟机所以没有设置)配置方法打开/etc/sysconfig/iptables文件找到22端口(这个是默认配置好的)复制多一行在下面把22改成3306就行记住不要复制到最后一行有些竟然没有iptables的文件这是可以生成的百度一下就行有些防火墙文件不是这个可能要先取消或者设置之前百度过忘了当然下面这个步骤也可以用vim命令进行编辑修改完保存之后执行命令行重启防火墙[rootlocalhost mysql] service iptables restart有些Linux版本的重启如下[rootlocalhost mysql] systemctl restart iptables.service16、测试连接本地使用Navicat连接测试填写完点击连接测试显示错误信息不允许连接1130 - Host 192.168.114.1 is not allowed to connect to this MySQL server解决方法(如果还没登录mysql记得登录先)mysql flush privileges;mysql GRANT ALL PRIVILEGES ON *.* TO myuser% IDENTIFIED BY mypassword WITH GRANT OPTION;mysql flush privileges;执行完再次连接测试还是报错1045 - Access denied for user root192.168.114.1 (using password:YES)不过这次结果是密码错误原因是因为未授权第一次启动是这样的解决如下mysql grant all privileges on *.* to root% identified by root;mysql flush privileges;再去连接测试就行了到这里就已经安装完毕可以使用了
