重启库:
sudo /sbin/service mysqld restart
连接库:
本机: mysql -u root -p
其它机器: mysql -h <host> -u root -p
查看库:
show databases;
查看表:
show tables;
创建库azkaban:
CREATE DATABASE azkaban;
进入库azkaban:
use azkaban;
创建用户:
CREATE USER 'username'@'%' IDENTIFIED BY 'password';
赋权:
GRANT SELECT,INSERT,UPDATE,DELETE ON <database>.* to '<username>'@'%' WITH GRANT OPTION;
执行一个sql文件:
mysql>source test.sql
sudo /sbin/service mysqld restart
连接库:
本机: mysql -u root -p
其它机器: mysql -h <host> -u root -p
查看库:
show databases;
查看表:
show tables;
创建库azkaban:
CREATE DATABASE azkaban;
进入库azkaban:
use azkaban;
创建用户:
CREATE USER 'username'@'%' IDENTIFIED BY 'password';
赋权:
GRANT SELECT,INSERT,UPDATE,DELETE ON <database>.* to '<username>'@'%' WITH GRANT OPTION;
执行一个sql文件:
mysql>source test.sql