MySQL数据库环境搭建和编程
MySQL环境安装设置
ubuntu环境安装mysql-server和mysql开发包,包括mysql头文件和动态库文件,命令如下:
sudo apt-get install mysql-server =》 安装最新版MySQL服务器
sudo apt-get install libmysqlclient-dev =》 安装开发包
ubuntu默认安装最新的mysql,但是初始的用户名和密码是自动生成的,按下面步骤修改mysql的root用户密码为123456
【step 1】
tony@tony-virtual-machine:~$ sudo cat /etc/mysql/debian.cnf
[client]
host = localhost
user = debian-sys-maint 《============== 初始的用户名
password = Kk3TbShbFNvjvhpM 《=============== 初始的密码
socket = /var/run/mysqld/mysqld.sock
【step 2】用上面初始的用户名和密码,登录mysql server,修改root用户的密码,必须先清空密码,命令如下:
tony@tony-virtual-machine:~$ mysql -u debian-sys-maint -pKk3TbShbFNvjvhpM
命令解释: -u后面是上面查看的用户名 -p后面紧跟上面查看的密码
mysql>use mysql;
flush privileges;
mysql>UPDATE user SET authentication_string="" WHERE user="root";//先把root密码置为空
mysql>flush privileges;
mysql>ALTER user 'root'@'localhost' IDENTIFIED BY 'Lrj@123lrj';//再重置密码
注意:密码格式必须符合要求,不然会报错的。mysql8貌似是要求必须包括大小写,数字和特殊字符。
【step 3】重新用root和123456登录mysql-server
lirenjie@lirenjie-virtual-machine:~$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 43
Server version: 8.0.36-0ubuntu0.22.04.1 (Ubuntu)
Copyright (c) 2000, 2024, Oracle and/or its affiliates.
【step 4】设置MySQL字符编码utf-8,可以支持中文操作
mysql> show variables like "char%";
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8mb4 |
| character_set_connection | utf8mb4 |
| character_set_database | utf8mb4 |
| character_set_filesystem | binary |
| character_set_results | utf8mb4 |
| character_set_server | utf8mb4 |
| character_set_system | utf8mb3 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (1.58 sec)
这里已经支持中文编码和操作了
标签:set,配置,Linux,character,密码,mysql,MySQL,root From: https://www.cnblogs.com/AndreaDO/p/18111257