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