关闭外键检查:
SET FOREIGN_KEY_CHECKS = 0
创建新用户
grant all on dbname.tablename to username@hostname identified by ‘password’;
关闭外键检查:
SET FOREIGN_KEY_CHECKS = 0
创建新用户
grant all on dbname.tablename to username@hostname identified by ‘password’;
[root@db1 ~]# service mysqld status
mysqld (pid 2965) is running…
[root@db1 ~]# service mysqld restart
Timeout error occurred trying to stop MySQL Daemon.
Stopping MySQL: [FAILED]
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL: [FAILED]