本文共 1046 字,大约阅读时间需要 3 分钟。
环境:
Ubuntu 18.04.21> 在线安装
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 restart3> 常规操作
修改登录密码:
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转载地址:http://oyhdi.baihongyu.com/