环境:
Ubuntu 18.04.2
1> 在线安装
sudo apt install mysql-server mysql-client
sudo apt libmysqlclient-dev //可选
2> 推荐配置
打开配置文件:
/etc/mysql/mysql.conf.d/mysqld.cnf
在[mysqld]下:
添加:
#中文支持
character-set-server=utf8
#存储过程group_concat函数拼接长度限制
group_concat_max_len = 1024000
修改:
#最大文件接收限制
max_allowed_packet = 200M
重启服务:
sudo service mysql restart
3> 常规操作
修改登录密码:
Mysql 5.7:
update mysql.user set authentication_string=password("123456"), plugin="mysql_native_password" where user='root';
flush privileges;
//查询
select host,user,authentication_string,plugin from mysql.user;
旧版:
update mysql.user set password = password('123456') where user = 'root';
flush privileges;
//查询
select host,user,password,plugin from mysql.user;
大文件导入使用指令:
mysql -uroot -p dbname < bigdata.sql
备份数据库:
mysqldump -u root -p dbname > dbname.sql
备份数据库表:
mysqldump -u root -p dbname tbname > tbname.sql
创建登录账户:
grant all on *.* to user_name@'%' identified by 'user_password';
开启外网连接:
打开配置文件/etc/mysql/mysql.conf.d/mysqld.cnf
把配置项”bind-address = 127.0.0.1”注释
重启服务:
sudo service mysql restart