随笔分类 -  mysql技术

我的mysql技术学习
You probably tried to upload too large file. Please refer to documentation for ways to workaround this limit.
摘要:方法一:打开 php.ini 修改配置文件,查找以下三个地方 upload_max_filesize , memory_limit 和 post_max_size ,将其值修改为大于要导入的数据库的值,重启 Apache ,这样就可以导入大于 2M 的数据库了。方法二:打开phpmyadmin,找到config.sample.inc.php文件,找到并修改为 $cfg['UploadDir'] = "upload"; 然后点保存.再打开config.default.php文件,找到并修改为 $cfg['UploadDir'] = " 阅读全文
posted @ 2014-02-18 17:05 杀出个黎明 阅读(428) 评论(0) 推荐(0)
Wrong permissions on configuration file, should not be world writable!
摘要:权限改成755就可以 阅读全文
posted @ 2014-02-18 16:48 杀出个黎明 阅读(210) 评论(0) 推荐(0)
mysql.proc错误解决
摘要:mysql_upgrade --force -h localhost -u root -p 阅读全文
posted @ 2011-10-31 11:27 杀出个黎明 阅读(442) 评论(0) 推荐(0)
mysql获取远程用户登录权限语句
摘要:CREATE USER 'itpro'@'%' IDENTIFIED BY '123';GRANT ALL PRIVILEGES ON *.* TO 'itpro'@'%' IDENTIFIED BY '123'WITH GRANT OPTIONMAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0; 阅读全文
posted @ 2011-08-02 10:38 杀出个黎明 阅读(316) 评论(0) 推荐(0)