1 安装mysql
sudo apt-get install update
sudo apt-get install mysql-server libmysqlclient-dev
2 登录mysql并进行配置
sudo mysql -u root // 进入mysql
use mysql;
select host, user from user;
update user set host='%' where user='root';
alter user 'root'@'%' identified with mysql_native_password by '你的密码';
flush privileges;
exit
3 修改mysql IP绑定
cd /etc/mysql/mysql.conf.d
sudo vi mysqld.cnf
// 将地址改一下
bind-address = 0.0.0.0
mysqlx-bind-address = 0.0.0.0
4 重启mysql
sudo service mysql restart
5 完毕
6 测试
c++代码测试可参考
代码编译命令:
g++ test.cpp -o test -lmysqlclient -I/usr/local/mysql/include/mysql/ -L/usr/local/mysql/lib/mysql
// g++ test.cpp -o test 有些不加后面的也可以
参考资料:
(1)ubuntu22.04安装mysql8并授权远程登陆_哔哩哔哩_bilibili
(2)Ubuntu c++ MySQL数据库操作_ubuntu操作数据库_小鱼仙官的博客-CSDN博客
(3)mysql报错,mysql报错_不教书的塞涅卡的博客-CSDN博客
(4)MYSQL设置密码时显示Failed! Error: SET PASSWORD has no significance for user ‘root‘@‘localhost‘ as the authe_宋你一袋馒头的博客-CSDN博客