石家庄建设公司网站,宁波标志设计公司,4a广告公司排名,毕业设计和论文网站1.准备工作①官网下载#xff1a;https://dev.mysql.com/downloads/mysql/5.6.html#downloads下载之后上传到服务器。②创建linux组用户groupadd mysqluseradd -g mysql mysql2.安装①解压#xff0c;比如放到了/usr/local/,进入到该目录下#xff0c;进行用z解压gz包#…1.准备工作①官网下载https://dev.mysql.com/downloads/mysql/5.6.html#downloads下载之后上传到服务器。②创建linux组用户groupadd mysqluseradd -g mysql mysql2.安装①解压比如放到了/usr/local/,进入到该目录下进行用z解压gz包然后改名为mysql文件夹。[rootlocalhost ~]# cd /usr/local/[rootlocalhost local] tar -xzvf mysql-5.6.41-linux-glibc2.12-x86_64.tar.gz[rootlocalhost local] mv mysql-5.6.41-linux-glibc2.12-x86_64 mysql②设置mysql目录属主属组都为上面添加的组和用户mysql[rootlocalhost local] chown -R mysql.mysql mysql③安装和配置[rootlocalhost local] cd mysql[rootlocalhost mysql]./scripts/mysql_install_db --usermysql --basedir/usr/local/mysql/ --datadir/usr/local/mysql/data/注若执行以上最后一个命令出现以下问题问题1FATAL ERROR: please install the following Perl modules before executing./scripts/mysql_install_db:Data::Dumper解决方法 安装autoconf库命令: yum -y install autoconf //此包安装时会安装Data:Dumper模块问题2Installing MySQL system tables.../usr/local/mysql//bin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory原因缺少libaio库文件解决方法yum install libaio* -y安装完成重新执行安装命令[rootlocalhost mysql]./scripts/mysql_install_db --usermysql --basedir/usr/local/mysql/ --datadir/usr/local/mysql/data/3.配置①配置my.cnf可以copy或者网上下一个里面参数文件路径要对。[rootlocalhost mysql] cp support-files/my-default.cnf /etc/my.cnf[rootlocalhost mysql] vim /etc/my.cnf[mysql]# 设置mysql客户端默认字符集default-character-setutf8socket/var/lib/mysql/mysql.sock[mysqld]#skip-name-resolve#设置3306端口port 3306socket/var/lib/mysql/mysql.sock# 设置mysql的安装目录basedir/usr/local/mysql# 设置mysql数据库的数据的存放目录datadir/usr/local/mysql/data②配置启动项创建配置文件中的不存在的路径和权限mkdir /var/lib/mysqlchown -R mysql:mysql /var/lib/mysql[rootlocalhost mysql]# cp ./support-files/mysql.server /etc/rc.d/init.d/mysqld[rootlocalhost mysql]# chmod x /etc/rc.d/init.d/mysqld #添加执行权限[rootlocalhost mysql]# chkconfig --add mysqld #加入到系统服务[rootlocalhost mysql]# chkconfig --list mysqld #检查是否生效生效以后就可以用service命令控制启动和停止[rootlocalhost mysql]# service mysqld start #启动mysql如果启动不了执行mv /etc/my.cnf /etc/my.cnf.bak执行后再次启动mysql就行了。4.环境变量配置#能正常启动服务无法登录需要配置环境变量[rootlocalhost mysql]# vim /etc/profileexport PATH$PATH:/usr/local/mysql/bin #文件最后添加这一句指向你的安装目录bin,保存退出[rootlocalhost mysql]# source /etc/profile #立即生效5.再次测试登录mysql发现就能成功了。[rootlocalhost mysql]mysql #直接mysql就能进入或者做初始化设置。[rootlocalhost mysql]mysql_secure_installation #初始化设置报错ERROR 2002 (HY000): Cant connect to local MySQL server through socket /tmp/mysql.sock (2)解决因为/tmp下不存在mysql.sock, 通过find / -name *.sock 发现在这里 /var/lib/mysql/mysql.sock建立个软链接到/tmp下就行 ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock再次初始化[rootlocalhost mysql]mysql_secure_installation就正常了。
