linux安装mysql

linux安装mysql

apt update
apt-get install mysql-server
mkdir -p /var/run/mysqld
chown mysql /var/run/mysqld/
service mysql restart

初始化mysql配置

mysql_secure_installation

mysql登陆

mysql -u<username> -p<password>

设置密码

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'admin123';
flush privileges;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'IDENTIFIED BY '123123' WITH GRANT OPTION;
grant all on *.* to root@'%' identified by 'mysql123';
flush privileges;

ubuntu修改mysql的绑定端口

步骤1. 打开mysql的配置文件，这里是默认安装的路径

vim /etc/mysql/mysql.conf.d/mysqld.cnf

步骤2. 在末行添加 port = 36993

步骤3. 保存后，重启mysql服务，service mysql restart

步骤4. 命令行登录进mysql，mysql -u root -p

步骤5. 查看开放的端口号，show variables like ‘port’;

Ubuntu下开启MySQL远程连接权限

一、将用户的访问地址改为%

打开终端登录mysql数据库：

mysql -u root -p

查看user表

mysql> use mysql;
Database changeed
mysql>select host, user, authentication_string from user;
mysql> update user set host = '%' where user = 'root';

二、注释bind-address = 127.0.0.1

vim /etc/mysql/mysql.conf.d/mysqld.cnf
#bind-address = 127.0.0.1
service mysql restart

show datebases;
use classify;
show tables;
show columns from exists_errortype;
describe exists_errortype;