![](https://img-blog.csdnimg.cn/20201014180756930.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Mysql
Mysql相关知识
阿蔡BLOG
记录工作与学习中点滴,总结没有坏处,学习永远不晚!
展开
-
YUM安装MYSQL8.0.35
【代码】YUM安装MYSQL8.0.35。原创 2023-12-11 09:42:43 · 610 阅读 · 0 评论 -
MYSQL几个基础知识
一、MYSQL默认目录结构源码安装mysql :mysql 主配置目录:/usr/local/mysql55mysql 数据目录:/data/mysqlmysql 命令目录:/usr/local/mysql55/bin/mysql 配置文件:/usr/local/mysql55/my.cnfmysql 启动文件:/usr/local/mysql55/support-files/mysql.server或者是/etc/init.d/mysqldmysql 日志文件:/data/mysql原创 2021-08-19 11:54:20 · 68 阅读 · 0 评论 -
报错:Enter password: ERROR 1045 (28000): Access denied for user ‘root‘@‘localhost‘ (using password: Y
登录mysql,报错:Enter password:ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: YES)[root@node02 mysql57]# /usr/local/mysql57/bin/mysql -uroot -pEnter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (us原创 2021-08-19 11:08:09 · 3240 阅读 · 0 评论 -
报错:ERROR 1054 (42S22): Unknown column ‘password‘ in ‘field list‘
mysql登录密码不记得了,登录不进去,本想修改mysql密码,结果报错了。ERROR 1054 (42S22): Unknown column ‘password’ in ‘field list’mysql> use mysql;Reading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -ADat原创 2021-08-19 10:39:26 · 2044 阅读 · 0 评论 -
源码安装MYSQL
源码安装mysql 5.71、安装依赖yum -y install gcc-c++ ncurses-devel cmake make perl gcc autoconf automake zlib libxml libgcrypt libtool bison openssl-devel下载Boost库Boost库是为C++语言标准库提供扩展的一些C++程序库的总称,由Boost社区组织开发、维护wget http://nchc.dl.sourceforge.net/project/boost/b原创 2021-08-18 15:46:16 · 1066 阅读 · 0 评论 -
部署MYSQL主从同步
两台主机:主库:192.168.68.125从库:192.168.68.126一、安装MYSQL,主库采用yum安装,从库采用源码编译安装。MYSQL主从同步,MYSQL版本需要一致。1、YUM安装主库:yum install mariadb mariadb-server mariadb-devel2、源码安装从库查看从库MYSQL版,确认与主库一致。这里使用mariadb-5.5.65下载,预编译,编译,安装cd /usr/srcwget http://mirrors.163.com原创 2020-10-01 21:05:18 · 202 阅读 · 0 评论