目录
1.安装mysql
apt-get install mariadb-server-10.0
为什么是 mariadb-server -10而不是 mysql 简单来说 mariadb-server是MySQL一个分支
2.设置root 密码
mysql
use mysql;
UPDATE user SET password=password('password') WHERE user='root';
UPDATE user SET plugin='mysql_native_password' WHERE user = 'root';
flush privileges;
3.修改配置文件 开启远程链接
vi /etc/mysql/mariadb.conf.d/50-server.cnf
4.修改root权限
mysql -u root -p 登录
执行下面的sql
USE mysql;
UPDATE user SET host = '%' WHERE user = 'root';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '' WITH GRANT OPTION;
FLUSH PRIVILEGES;
5.重启mysql(修改配置文件后必须)
sudo service mysql stop
sudo service mysql start
6.卸载------------------>
sudo apt-get autoremove --purge mysql-server
sudo apt-get remove mysql-server
sudo apt-get autoremove mysql-server
sudo apt-get remove mysql-common
dpkg -l |grep ^rc|awk '{print $2}' |sudo xargs dpkg -P
7.表名大小写忽略问题
-- 查看现有的配置
show variables like "%case%";
--lower_case_table_names就是控制mysql
--是否区分表名大小写的配置项,
--1代表不区分,0代表区分大小写。
修改配置
vi /etc/mysql/mariadb.conf.d/50-server.cnf
加入
lower_case_table_names=1
如下图