mysql中的中文乱码问题的解决:
对于mysql中出现的中文乱码问题,我没有修改mysql的配置文件,而是直接在建表时设置charset为uft8。default charset=uft8;
查看mysql的运行状态
service mysql status
停止运行
service mysql stop
开始运行
service mysql start
其他问题
报错
root@biwenjing:/home/piaoya# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
$ service mysql start
查看数据库的用户名
进入mysql
select user,host from mysql.user;
+------------------+-----------+
| user | host |
+------------------+-----------+
| debian-sys-maint | localhost |
| mysql.session | localhost |
| mysql.sys | localhost |
| root | localhost |
+------------------+-----------+
4 rows in set (0.00 sec)
对于解决mysql中文乱码的相关文章:https://blog.csdn.net/u012410733/article/details/61619656
Linux下修改mysql的配置文件详解:https://blog.csdn.net/Quan_qqqq/article/details/91528583
SQL练习题目(部门员工表)
https://blog.csdn.net/Fenggms/article/details/83034175
网友评论