MYSQL安装
1。官网下载mysql最新版
wget https://repo.mysql.com//mysql-apt-config_0.8.10-1_all.deb
解压:sudo dpkg -i …
显示OK后
apt-get update
2.使用sudo apt install mysql-server
创建用户
命令:
mysql8需要
使用sudo mysql_upgrade -u 用户名 -p
添加新用户;
允许本地IP访问localhost,127.0.0.1
create user ‘用户名’@‘localhost’ identified by ‘密码’;
允许外网访问
create user ‘用户名’@’%’ identified by ‘密码’;
授权:
命令:
mysql 5.7版本
grant all privileges on . to ‘用户名’@’%’ identified by ‘密码’ WITH GRANT OPTION;
mysql 8.0版本
grant all privileges on . to ‘用户名’@’%’ WITH GRANT OPTION;
刷新授权
flush privileges;
设置与更改用户密码
命令:
SET PASSWORD FOR ‘username’@‘host’ = PASSWORD(‘newpassword’);
如果是当前登陆用户用:
SET PASSWORD = PASSWORD(“newpassword”);
例子:
SET PASSWORD FOR ‘pig’@’%’ = PASSWORD(“123456”);
启动
mysql -u root -p
显示数据库列表 show databases
建库create database 库名
进入use 库名
建表create table 表名
删库和删表:
drop database 库名
drop table 表名
更改端口
vi /etc/mysql/mysql.conf.d/mysqld.cnf