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;