mysql安装
1.准备工作
检查是否安装过mysql:
#rpm -qa | grep mysql
如果有安装过,卸载并删除所有相关目录和文件:
#rpm -e --nodeps XXXXXX
#whereis mysql
#find / -name mysql
检查mysql用户和组是否存在,如果没有,创建:
[root@localhost /]# cat /etc/group | grep mysql
[root@localhost /]# cat /etc/passwd |grep mysql
[root@localhost /]# groupadd mysql
[root@localhost /]# adduser -r -g mysql mysql
准备安装包,确定安装目录
2.解压安装包到指定目录
将解压得到的目录重命名为mysql
3.创建data
在mysql下创建data目录
[root@localhost /]# mkdir /usr/local/mysql/data
4.更改mysql目录下所有的目录及文件夹所属的用户组和用户,以及权限
[root@localhost /]# chown -R mysql:mysql /usr/local/mysql
[root@localhost /]# chmod -R 755 /usr/local/mysql
5.初始化mysql 并记录输出日志最后的临时密码 v)TXOLsNt8Zn
[root@localhost /]# cd /usr/local/mysql/bin
[root@localhost bin]# ./mysqld --initialize --user=mysql --datadir=/usr/local/mysql/data --basedir=/usr/local/mysql
6.编辑配置文件my.cnf
[root@localhost bin]# vi /etc/my.cnf
[mysqld]
datadir=/usr/local/mysql/data
socket=/var/lib/mysql/mysql.sock
port=8535
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
symbolic-links=0
max_connections=600
innodb_file_per_table=1
lower_case_table_names=1
bind-address=0.0.0.0
[mysql]
socket=/var/lib/mysql/mysql.sock
7.测试启动
[root@localhost /]# /usr/local/mysql/support-files/mysql.server start
8.添加软连接重启mysql服务
[root@localhost /]# ln -s /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
[root@localhost /]# ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql
[root@localhost /]# service mysql restart
9.登陆,修改初始密码
[root@localhost /]# mysql -u root -p
Enter password:
mysql>set password for root@localhost = password('Z8HTl#mgH3Ry');
10.放开远程链接
mysql>use mysql;
msyql>update user set user.Host='%' where user.User='root';
mysql>flush privileges;
11.配置环境变量