MySQL
iteye_15182
这个作者很懒,什么都没留下…
展开
-
YUM安装MYSQL后,第一次启动时的安全提示
MySQL 5.1.69[root@localhost init.d]# ./mysqld start Initializing MySQL database: Installing MySQL system tables... OK Filling help tables... OK To start mysqld at boot time you...2013-11-19 08:32:47 · 167 阅读 · 0 评论 -
Linux环境MySQL的安装及配置
1. 安装MySQL-Server(yum)[root@localhost ~]# yum list | grep mysql [root@localhost ~]# yum install mysql-server.x86_64 2. 配置: 表名不区分大小写配置 打开文件[root@localhost ~]# vi /etc/my.cnf ...原创 2014-01-21 14:58:18 · 101 阅读 · 0 评论 -
MySQL问题集锦
一、下载(免安装Archive版) 下载地址:http://dev.mysql.com/downloads/mysql/ 二、安装1.解压到目录:D:\mysql-5.1.59-winx642.注册mysql服务,命令行跳转到D:\mysql-5.1.59-winx64\bin,执行以下命令:D:\mysql-5.1.59-winx64\bin>...原创 2013-03-27 17:18:15 · 82 阅读 · 0 评论 -
CentOS 6.4 系统,使用YUM升级MySQL5.1.x到MySQL5.6.x
1. 下载MySQL Yum 仓库 Download MySQL Yum Repository 2. 安装 mysql-community-release-el6-5.noarch.rpmrpm -ivh mysql-community-release-el6-5.noarch.rpm3. 停止MySQLservice mysqld stop 4. ...原创 2014-10-24 15:12:48 · 118 阅读 · 0 评论 -
MySQL自动备份
1. 添加备份用户mysql> insert into user(user,host,password) values('backup','localhost',password('backup'));Query OK, 1 row affected, 3 warnings (0.00 sec)mysql> flush privileges;Query OK, ...2014-10-29 16:41:56 · 84 阅读 · 0 评论 -
MySQL异常备忘录
1. 超过最大连接数1.1 异常信息 ERROR 1040: Too many connectionscom.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Data source rejected establishment of connection, message from server: "...2014-11-04 09:11:17 · 275 阅读 · 0 评论