营销网站搭建建议,网站建设和网袷宣传,网页设计与制作步骤教程,广告设计创意使用系统为Ubuntu2404#xff0c;mysql8版本为8.0.36
安装mysql
apt install -y mysql-server设置开机自启动
systemctl enable --now mysql修改密码#xff0c;似乎是bug#xff0c;修改密码第一次不成功#xff0c;第二次可以
mysql
use mysql;
update user set Host…使用系统为Ubuntu2404mysql8版本为8.0.36
安装mysql
apt install -y mysql-server设置开机自启动
systemctl enable --now mysql修改密码似乎是bug修改密码第一次不成功第二次可以
mysql
use mysql;
update user set Host% where Userroot;
ALTER USER root% IDENTIFIED BY 000000;
ALTER USER root% IDENTIFIED BY 000000;
FLUSH PRIVILEGES;修改用户认证方式
ALTER USER rootlocalhost IDENTIFIED WITH mysql_native_password BY 000000;
ALTER USER root% IDENTIFIED WITH mysql_native_password BY 000000;
FLUSH PRIVILEGES;修改监听地址
vi /etc/mysql/mysql.conf.d/mysqld.cnfbind-address 0.0.0.0重启
systemctl restart mysql远程测试连接
PS C:\Users\huhy mysql -h 192.168.200.190 -uroot -p
Enter password: ******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 13
Server version: 8.0.36-2ubuntu3 (Ubuntu)Copyright (c) 2000, 2024, Oracle and/or its affiliates.Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.Type help; or \h for help. Type \c to clear the current input statement.mysql客户端工具测试连接 脚本如下
