//新增用户
grant all privileges on *.* to root@'%' identified by "root";//立即生效
flush privileges;grant select,insert,update,delete,create,drop on to joe@10.163.225.87 identified by ‘123′;grant all on xxxDB.* to xxx@'%';
MySQL提示“Checking for tables which need an upgrade, are corrupt or were not closed cleanly”
$ sudo service mysql stop
$ sudo /etc/init.d/apparmor reload
$ sudo service mysql start
或者:
down vote
This error occurs due to multiple installations of mysql. Run the command:
$ ps -A|grep mysql
Kill the process by using:
$ sudo pkill mysql
and then run command:
$ ps -A|grep mysqld
Also Kill this process by running:
$ sudo pkill mysqld
Now you are fully set just run the following commands:
$ service mysql restart
mysql -u root -p
7z相关操作
1
2
3
4
//压缩
$ 7z a -t7z -r manager.7z /home/manager/*
//解压
$ 7z X xx.zip
腾讯云修改密码,允许root登录
1
2
3
4
5
$ sudo passwd root
$ sudo vi /etc/ssh/sshd_config
$ sudo service ssh restart