asp网站耗资源,旅游电子商务网站策划书,王烨森,东营建设银行电话号码本教程为大家分享了mysql5.6.33在linux下的安装配置方法#xff0c;供大家参考#xff0c;具体内容如下1、下载下载地址#xff1a;http://dev.mysql.com/downloads/mysql/5.6.html#downloads下载版本#xff1a;我这里选择的5.6.33#xff0c;通用版#xff0c;linux下6…本教程为大家分享了mysql5.6.33在linux下的安装配置方法供大家参考具体内容如下1、下载下载地址http://dev.mysql.com/downloads/mysql/5.6.html#downloads下载版本我这里选择的5.6.33通用版linux下64位也可以直接复制64位的下载地址通过命令下载复制代码 代码如下:wget http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.33-linux-glibc2.5-x86_64.tar.gz2、解压#解压tar -zxvf mysql-5.6.33-linux-glibc2.5-x86_64.tar.gz#复制解压后的mysql目录cp -r mysql-5.6.33-linux-glibc2.5-x86_64 /usr/local/mysql3、添加用户组和用户#添加用户组groupadd mysql#添加用户mysql 到用户组mysqluseradd -g mysql mysql4、安装cd /usr/local/mysql/mkdir ./data/mysqlchown -R mysql:mysql ././scripts/mysql_install_db --usermysql --datadir/usr/local/mysql/data/mysqlcp support-files/mysql.server /etc/init.d/mysqldchmod 755 /etc/init.d/mysqldcp support-files/my-default.cnf /etc/my.cnf#修改启动脚本vi /etc/init.d/mysqld#修改项basedir/usr/local/mysql/datadir/usr/local/mysql/data/mysql#启动服务service mysqld start#测试连接./mysql/bin/mysql -uroot#加入环境变量编辑 /etc/profile这样可以在任何地方用mysql命令了export PATH$PATH:/usr/local/mysql//binsource /etc/profile#启动mysqlservice mysqld start#关闭mysqlservice mysqld stop#查看运行状态service mysqld status5、错误5.1 sqlyog连接时报1130错误是由于没有给远程连接的用户权限问题解决1更改 ‘mysql数据库‘user表‘host项从‘localhost改成‘%。use mysql;select host from user where userroot;update user set host % where user root;flush privileges;解决2直接授权复制代码 代码如下:GRANT ALL PRIVILEGES ON *.* TO ‘root% IDENTIFIED BY ‘youpassword WITH GRANT OPTION;5.2 安装时的一些错误-bash: ./scripts/mysql_install_db: /usr/bin/perl: bad interpreter: 没有那个文件或目录解决yum -y install perl perl-develInstalling MySQL system tables..../bin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory解决yum -y install libaio-devel6、其他6.1 配置环境变量vi /etc/profileexport PATH....:/usr/local/mysql/bin精彩专题分享mysql不同版本安装教程mysql5.6各版本安装教程mysql5.7各版本安装教程mysql8.0各版本安装教程以上就是本文的全部内容希望对大家的学习有所帮助也希望大家多多支持易采站长站。
