终端进入mysql:
user$ /usr/local/mysql/bin/mysql -uroot -p
启动/停止/重启mysql服务:
user$ sudo /usr/local/MySQL/support-file/mysql.server start
user$ sudo /usr/local/MySQL/support-file/mysql.server stop
user$ sudo /usr/local/MySQL/support-file/mysql.server restart
修改数据库表编码:
mysql>alter table tablename convert to character set utf8mb4 collate utf8mb4_unicode_ci;
修改数据库编码:
mysql>alter database databasename character set utf8mb4 collate utf8mb4_unicode_ci;
mysql导入.sql文件
mysql>use databasename;
mysql>source /${Path}/name.sql