mysql操作

mysql启动：

　　mysqld_safe --defaults-file=/etc/my.cnf --user=mysql --datadir=/var/lib/mysql

mysql关闭：

　　mysqladmin -S /tmp/mysql${port}.sock shutdown  -u$user -p$password

创建系统表：

　　mysql_install_db --user=mysql --datadir=/var/lib/mysql/

修改mysql的端口：

　　修改/etc/my.cnf文件，在[mysqld]下 添加 port=3303

[mysqld]
datadir=/var/lib/mysql3303
socket=/var/lib/mysql3303/mysql.sock
port=3303
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld3303.log
pid-file=/var/run/mysqld/mysqld3303.pid
~

 访问mysql：

　　mysql -S /var/lib/mysql3303/mysql.sock -P 3303  -u user -p

创建数据库的用户：

　　GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO repl@‘192.168.0.%‘ IDENTIFIED BY ‘p4ssword‘;

　　GRANT ALL PRIVILEGES ON *.* TO ‘myuser‘@‘%‘ IDENTIFIED BY ‘mypassword‘ WITH GRANT OPTION;

　　 flush privileges;

mysql操作,布布扣,bubuko.com

mysql操作

原文：http://www.cnblogs.com/fanweiwei/p/3580462.html