mysql-linux 安装


linux

1、解压复制

tar -zxvf /usr/local/java/mysql-5.6.31-linux-glibc2.5-x86_64.tar.gz
cp -r /usr/local/java/mysql-5.6.31-linux-glibc2.5-x86_64 /usr/local/mysql


2、用户java/


cd /usr/local/java
groupadd mysql
添加用户组
useradd –g msyql mysql
添加mysql用户名


3、安装 mysql


cd /usr/local/mysql
chown -R mysql:mysql ./
给mysql文件授权
mkdir /usr/local/mysql/data/mysql
创建数据存放文件夹
./scripts/mysql_install_db --user=mysql --datadir=/usr/local/mysql/data/mysql
安装


4、服务加载mysql


cd /usr/local/mysql
cp support-files/mysql.server /etc/init.d/mysqld
最后这个是服务名字,可以修改
chmod 755 /etc/init.d/mysqld
授予Mysql.service 可以执行权限


5、配置mysql配置文件


cd /usr/local/mysql
cp support-files/my-default.cnf /etc/my.cnf
vim /etc/my.cnf
更改
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data/mysql


6、测试/启动服务mysql

这一步是错误的,直接下一步


service mysql start

7.设置密码

可以


cd /usr/local/mysql/bin
./mysqladmin -u root password root
设置用户名密码


8、启动


启动
service mysql/mysqld start
登录
cd /usr/local/mysql/bin
./mysql
无密码时登录
./mysql -u用户名 -p密码
./mysql -hlocalhost -uroot –proot


9、远程登录


UPDATE user SET `Host` = '%' WHERE `User` = 'root';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '连接密码' WITH GRANT OPTION;

刷新权限:

flush privileges;


10、关闭防火墙


systemctl stop firewalld