摘要：#首先执行看mysql是否开启函数SHOW VARIABLES LIKE '%func%';------------------------------------------------------------------------------#如果没有开启（OFF）则设置开启SET GLOBAL log_bin_trust_function_creators=1;------------------------------------------------------------------------------#下面是一个测试函数DELIMITER $$CREATE 阅读全文

摘要：先登入mysqlmysql -u root -p然后回车键入密码！1.2 赋予主机B操作数据库的权限mysql> grant usage on *.* to username@192.168.0.1 identified by 'password';说明：赋予username@192.168.0.1使用所有数据库的权限，在主机192.168.0.1上使用username账户登录，密码为：passwordmysql> grant usage on *.* to username identified by 'password';说明：赋予usernam 阅读全文

摘要：创建mysql用户groupadd mysqluseradd -g mysql mysqlmysql编译安装wget http://downloads.mysql.com/archives/mysql-5.1/mysql-5.1.70.tar.gztar -zxvf mysql-5.1.70.tar.gzcd mysql-5.1.70 yum install ncurses ncurses-devel./configure '--prefix=/usr/local/mysql' '--without-debug' '--with-charset=utf8 阅读全文

摘要：echo "\n"; echo "\n"; $query="select * from user"; $result = mysql_query($query); for($i=0;$i".$row_1[0]."\n"; } echo "\n"; 阅读全文

摘要：最近采集了大批量的数据，在导入服务器的时候mysql报错：ERROR 20 (HY000) at line 31876: Disk is full writingdf-h 一下，发现磁盘满了，所以只好把mysql移动到其他盘里，话不多说开始吧：首先创建新mysql目录mkdir /home/mysqldata/停止mysqlservice mysqld stop移动数据库数据mv /var/lib/mysql　/home/mysqldata/更新配置文件路径vim /etc/my.cnf[mysqld]#datadir=/var/lib/mysqldatadir=/home/mysqldata 阅读全文