当前位置: 首页 > Linux

Linux下安装mysql

时间:2023-04-06 02:05:15 Linux

1、安装cmake(更高级的configure)到光盘获取cmake并安装(如果电脑联网也可以使用yuminstall-ycmake命令)rpm-ivhcmake*(直接TAB版本不同,并且下面也是不同的)2.安装ncurses-devel的rpm包,ncurses-devel相关的包rpm-ivhncurses-devel-*.rpm(直接TAB,后面是版本信息),方便后面的编译和安装。3.编译安装[root@localhost~]#tar-zxfmysql-5.5.17.tar.gz[root@localhost~]#cdmysql-5.5.17[root@localhost~]#cmake\-DCMAKE_INSTALL_PREFIX=/usr/local/mysql\-DMYSQL_DATADIR=/usr/local/mysql/data\-DDEFAULT_CHARSET=utf8\-DDEFAULT_COLLATION=utf8_general_ci(安装路径数据安装路径mysql字符集校对字符集)在解压后的压缩包下运行[root@localhost~]#make&&makeinstall4.复制到mysql一个配置文件[root@localhost~]#cp解压目录/support-files/my-medium.cnf/etc/my.cnfvim/etc/my.cnf#socket=/tmp/mysql.sock加入frontofsocket#注释掉他5.添加mysql用户[root@localhost~]#useraddmysql(mysql用户将存在同名mysql组下)[root@localhost~]#chmod+x/usr/local/mysql6.初始化mysql数据库(创建系统默认数据库等)[root@localhost~]#/usr/local/mysql/scripts/mysql_install_db\--user=mysql\--basedir=/usr/local/mysql\--datadir=/usr/local/mysql/data&注意:(用户安装mysql安装路径data的目录)7、将mysql安装目录下的文件(data除外)的属主改为root,所有文件所在组为mysql组,数据目录所有者改为mysql[root@localhost~]#chown-Rroot/usr/local/mysql[root@localhost~]#chown-Rmysql/usr/local/mysql/data[root@localhost~]#chgrp-Rmysql/usr/local/mysql8.后台运行mysql服务[root@localhost~]#/usr/local/mysql/bin/mysqld_safe--user=mysql&查看mysql是否启动(ps查看进程命令)[root@localhost~]#ps-一个|grepmysql测试数据库[root@localhost~]#/usr/local/mysql/bin/mysql-urootmysql>showdatabases;按照上一步,修改mysql密码(可选做这一步,默认没有密码)mysql>UPDATEuserSETPassword=password('123456')WHEREuser='root';mysql>刷新权限;9、配置mysql开机自启动服务项[root@localhost~]#cp源码包解压目录/support-files/mysql.server/etc/init.d/mysqld[root@localhost~]#chmod+x/etc/init.d/mysqld//设置可执行权限[root@localhost~]#chkconfig--addmysqld//加入系统服务[root@localhost~]#chkconfigmysqldon/off//设置开机自动启动10.设置mysql环境变量vim/ect/profileexportPATH=$PATH:/usr/local/mysql/bin(添加最后一行后保存退出)source/etc/profile(让环境变量立即生效)配置开机自启动:[root@localhost~]#vi/etc/rc.local添加如下命令/usr/local/apache/bin/apachectlstart(apache启动)servicevsftpdstart(ftp服务启动)