1.安装mysql:
sudo apt-get install mysql-server mysql-client
2.登陆:
mysql -u root -p u : usrname p : passwd
登录状态下,查看数据库当前编码:SHOW VARIABLES LIKE 'character%';
3.修改默认编码为utf-8:
修改/etc/mysql/my.cnf (默认安装路径下) ,追加到末尾,修改或者添加;
[mysqld]
character_set_server=utf8
[mysql]
default-character-set= utf8
[client]
default-character-set = utf8
4. mysql 操作命令:
停止MySQL:$ sudo systemctl stop mysql.service
启动MySQL:$ sudo systemctl start mysql.service
重启MySQL:$ sudo systemctl restart mysql.service
查看MySQL运行状态:$ sudo systemctl status mysql.service
5.远程访问授权:
(1)授权法;
use mysql;
grant all privileges on *.* to root@'%' identified by "password";
flush privileges;
(2)改表法:
use mysql;
update user set host = '%' where user = 'root';
6.重置root密码:
1、在/etc/mysql/my.cnf 中的mysqld 下新增
skip-grant-tables
2、重启mysql服务:sudo systemctl restart mysql.service
3、终端输入mysql进入
4、重置密码:
use mysql;
update user set authentication_string=password('root') where user='root';
flush privileges;
quit;
5、到my.cnf中去掉那句话,重启mysql服务,正常进入