mysql备忘

安装mysql

sudo apt-get install mysql-server

mysqlCLI

mysql -u root -p

mysql各种操作(启动关闭等)

/etc/init.d/mysql       

mysql配置地址

/etc/mysql/my.conf

修改mysql访问权限

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;