更新apt-get
sudo apt-get update
sudo apt-get upgrade
安装MySql
sudo apt-get install mysql-server
安装的过程中会提示你为mysql设置密码,可以直接设置。
安装完成后,可以使用以下命令尝试登录
mysqlmysql -u root -p或者直接 mysql
登录上mysql 可以使用以下命令查看mysql版本
selectversion();
添加MySql用户添加用户
# 创建 beta1025用户,设置密码为 123456
CREATE USER sunjiajian IDENTIFIED BY '123456';
# 授权
GRANT ALL PRIVILEGES ON *.* TO 'sunjiajian'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
# 更新权限
FLUSH PRIVILEGES;查看用户权限列表
使用该命令可以查看是否创建成功
SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;
MySQL远程访问
MySql默认是供本地访问的,因此需要更改下配置。首先查看3306端口号
默认显示127.0.0.1:3306,我们需要的是将它改为0.0.0.0:3306
netstat -an|grep 3306关闭MySql
service mysql stop切换到root用
su root修改MySql配置
vim /etc/mysql/mysql.conf.d/mysqld.cnf
将bind-address = 127.0.0.1更改为bind-address = 0.0.0.0 保存退出启动MySql
service mysql start
查看3306端口号是否为 0.0.0.0:3306远程连接mysql后,尝试用sql语句插入带自增主键属性的表,在略过主键插入时,虽然成功插入数据,但是会提示:[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'information_schema.PROFILING.SEQ' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
set @@global.sql_mode ='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';