select @@datadir;
show variables like 'basedir%'
show global variables;
mysql -u root -P 3307 -h 101.200.152.192 -p
mysql -uroot --port=3308
————————————————
版权声明:本文为CSDN博主「迷彩_风情」的原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接及本声明。
原文链接:https://blog.csdn.net/u013059432/article/details/78068148
mysqld --install Mysql5.7.29_3307 --defaults-file="C:\zs\mysql-5.7.29-winx64\my.ini"
mysqld --defaults-file="C:\zs\mysql-5.7.29-winx64\my.ini" --console --skip-grant-tables
mysqld --install Mysql5.7.29_3307--defaults-file="C:\zs\mysql-5.7.29-winx64\my.ini" --initialize --user=mysql --console --skip-grant-tables
mysqld --install Mysql5.7.29_3307 --defaults-file="C:\zs\mysql-5.7.29-winx64\my.ini"
unknown option '--initalize'
mysqld --defaults-file="C:\zs\mysql-5.7.29-winx64\my.ini"
mysqld --install Mysql5.7.29_3308 --defaults-file="C:\zs\mysql-5.7.29-winx64_3308\my.ini"
mysql --defaults-file="C:\zs\mysql-5.7.29-winx64\my.ini" -uroot -p
QkX+OcwRq1Do
tUer9/<=snwy
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: Y
ES)
CREATE USER 'keepsoft'@'%' IDENTIFIED BY 'keepsoft';
create user 'keepsoft'@'%' identified by 'keepsoft';
/mysql_install_db --usrer=mysql --datadir=/var/lib/mysql
mysqld - initialize mysqld --initialize-insecure
RROR 1396 (HY000): Operation CREATE USER failed for
mysqladmin -uroot -p123456 password 123456
grant replication slave on *.* to 'keepsoft2'@'%' identified by '123456';
flush privileges; #授权后需要刷新后,
change master to master_host='127.0.0.1',master_user='keepsoft2',master_password='123456',master_log_file='mysql-bin.000002',master_log_pos=154;
;%MYSQL3307_HOME%/bin;%MYSQL3308_HOME%/bin;
作者:程就人生
链接:https://www.jianshu.com/p/ccfa6867bda9
来源:简书
著作权归作者所有。商业转载请联系作者获得授权,非商业转载请注明出处。
才能生效;
作者:程就人生
链接:https://www.jianshu.com/p/ccfa6867bda9
来源:简书
著作权归作者所有。商业转载请联系作者获得授权,非商业转载请注明出处。