Ubuntu Linux安装MySQL并设置大小写不敏感

1.下载和安装更新源和安装MySQL。

cd /tmp
wget http://repo.mysql.com/mysql-apt-config_0.8.22-1_all.deb
sudo dpkg -i mysql-apt-config_0.8.22-1_all.deb
sudo apt-get update
sudo apt-get install mysql-server

2.设置大小写不敏感，找到MySQL的配置文件，正常情况一般在/etc/mysql/目录下,运行命令：

sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf

3.找到[mysqld]，在下面加一行：

lower_case_table_names=1  # 大小写不敏感

4.可选，关闭远程访问，找到并注释下面两行：

# bind-address          = 127.0.0.1
# mysqlx-bind-address   = 127.0.0.1

5.CTRL+O保存文件，CTRL+X退出。

6.重建并修改/var/lib/mysql目录权限

sudo  rm -rf /var/lib/mysql/

sudo mkdir /var/lib/mysql

sudo chown mysql:mysql /var/lib/mysql

 

6.初始化MySQL

sudo mysqld --initialize --user=mysql --lower-case-table-names=1

7.查看MySQL系统服务运行状态

sudo systemctl status mysql.service

#如果出现提示：
System has not been booted with systemd as init system (PID 1). Can't operate.

Failed to connect to bus: Host is down
#需要安装systemctl 

sudo apt install systemctl

8.重启MySQL服务

sudo systemctl restart mysql.service

9.重置MySQL密码

tail /var/log/mysql/error.log