MySQL命令详解与应用技巧

1）登录MySQL：mysql -u root –p。2）允许本地IP访问（localhost, 127.0.0.1）：insert into mysql.user(Host, User, Password) values('localhost', 'zhouz', password('1234'));。3）允许外网IP访问：insert into mysql.user(Host, User, Password) values('%', 'zhouz', password('1234'));。4）刷新授权：flush privileges;。5）创建数据库：create database zhouzdb DEFAULT CHARSET utf8 COLLATE utf8_general_ci;。6）授予用户通过外网IP对该数据库的全部权限：grant all privileges on zhouzdb.* to 'zhouz'@'%' identified by '1234';