Error 6 Hy000 Error On Delete Of
Office 2007 Windows 2003 Server PHP Date & Time Zend Studio Rackspace Rackspace Cloud WordPress ERROR 6 (HY000): Error on delete of ‘./database//db.opt' (Errcode: 13) Posted December 14, 2010 in MySql by medialam.Tags: MySql, MySql Server I was trying to drop a database in MySQL today but every time I did I got the error: ERROR 6 (HY000): Error on delete of './database//db.opt' (Errcode: 13) This was due to the fact permissions on the database folder were not allowing MySQL to delete the folder. There are a couple of ways you can fix this, either through the command line by finding the folder in question and changing the permissions to allow the MySQL user permissions, or through your FTP application, I am using WinSCP. Simply navigate to where you store your MySQL databases, right click on the folder in question and set the MySQL user to have read, write and execute permissions. You will now be able to drop the database. « Previous Post Next Post » Leave a Reply Cancel reply Your email address will not be published. Required fields are marked *Comment Name * Email * Website
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only http://www.tech-problems.com/error-6-hy000-error-on-delete-of-databasedb-opt-errcode-13/ takes a minute: Sign up Can't delete mysql database, table or even alter table inside docker up vote 0 down vote favorite I want to have a mysql database with some basic dataset. I create mysql docker image using this https://index.docker.io/u/brice/mysql/ Dockerfile, but delete VOLUME ["/var/lib/mysql", "/var/log/mysql"] line, so the Dockerfile looks like: FROM ubuntu:12.10 MAINTAINER Brandon Rice
首页 | 博文目录 | 关于我 warren20 博客访问: 208906 博文数量: 62 用 户 组: 普通用户 注册时间: 2015-03-03 14:33 个人简介 不断学习,突破自我 文章分类 全部博文(62) http://blog.itpub.net/30150152/viewspace-1745975/ hadoop(1) MYSQL(15) mysql监控(1) mysql字符集(2) 日志管理(1) 参数配置(3) SQL优化(1) 安装(3) 常见错误(3) Kettle(2) 常见错误(1) ORACLE(32) DATAGUARD(4) 数据迁移(1) 灾难恢复(1) 相关工具(1) expdp&&nbs(2) sql语句(3) RAC(1) 网络配置(1) http://www.developpez.net/forums/d1011932/bases-donnees/mysql/administration/error-6-hy000-error-on-delete/ 相关参数及实验(8) RMAN(2) 安装(5) ASM(3) python(3) 维护脚本(1) Powerdesigner(1) LINUX(5) 网络配置(1) SQLSERVER(1) 优化工具(1) SQL查询及优化(0) 未分配的博文(2) 文章存档 2016年(3) 2016年07月(1) 2016年05月(2) 2015年(59) 2015年12月(2) error 6 2015年11月(2) 2015年10月(2) 2015年09月(6) 2015年08月(8) 2015年07月(4) 2015年06月(1) 2015年05月(4) 2015年04月(8) 2015年03月(22) 我的朋友 破棉袄 最近访客 punish00 newcomer stonebox tolywang maqi528 stziyan mimymy loveshul lixiaohe 微信关注 IT168企业级官微 微信号:IT168qiye 系统架构师大会 微信号:SACC2013 订阅 推荐博文 ·【知识点整理】NOLOGGING、AP... ·dbms_addm执行oracle数据库诊... · 2016中国系统架构师大会门票... ·MBA中Safari访问Domino邮箱服... ·根据awr报告查看最慢的sql语... 热词专题 ERROR error 6 hy000 6 (HY000): Error on delete of './pms//db.opt' (Errcode: 13 2015-07-23 17:17:28 分类: MySQL
今天接收了一个别人的数据库,说是要清空表,结果我删表和删库都报错了 mysql> drop table phzc_user; ERROR 6 (HY000): Error on delete of './pms/phzc_user.frm' (Errcode: 13) mysql> mysql> mysql> drop database pms; ERROR 6 (HY000): Error on delete of './pms//db.opt' (Errcode: 13) 查看数据文件目录 [root@phzc_pa_dev_016 mysql]# ll total 79308 drwxr-xr-x 2 root root 4096 Jul 9 11:27 acct drwxr-xr-x 2 root root 4096 Jul 9 11:27 ams drwxr-xr-x 2 root root 4096 Jul 9 11:27 bak drwxr-xr-x 2 root root 4096 Jul 9 11:27 cfc -rw-r--r-- 1 mysql mysql 69206016 Jul 23 17:00 ibdata1 -rw-rw---- 1 mysql mysql 5242880 Jul 23 17:00 ib_logfile0 -rw-rw---- 1 mysql mysql 5242880 Jul 9 11:27 ib_logfMerise UML JavaPlateforme et langage Java Java Java Web Spring Android Eclipse NetBeans .NETMicrosoft Framework .NET Microsoft DotNET Visual Studio ASP.NET C# VB.NET Windows Phone Microsoft Azure Dv. WebDveloppement Web et Webmarketing Dveloppement Web AJAX Apache ASP CSS Dart Flash / Flex JavaScript PHP Ruby & Rails TypeScript Web smantique Webmarketing (X)HTML EDIEnvironnements de Dveloppement Intgr EDI 4D Delphi Eclipse LabVIEW NetBeans MATLAB Scilab Visual Studio WinDev Visual Basic 6 Lazarus Qt Creator ProgrammationProgrammation et langages de programmation applicatifs Programmation Dbuter - Algorithmique 2D - 3D - Jeux Assembleur C C++ Go Objective C Pascal Perl Python Swift Qt XML Autres SGBDSystmes de Gestion de Bases de Donnes SGBD & SQL 4D Access Big Data DB2 Firebird InterBase MySQL NoSQL PostgreSQL Oracle Sybase SQL-Server OfficeBureautique pour l'entreprise Microsoft Office Access Excel Word Outlook PowerPoint SharePoint Microsoft Project OpenOffice & LibreOffice Solutions d'entrepriseAutres logiciels pour l'entreprise Solutions d'entreprise Big Data BPM Business Intelligence ERP / PGI CRM SAS Cloud Computing SAP Microsoft BizTalk Server Talend IBM Bluemix ApplicationsApplications logicielles Applications Libres & Open Source OpenOffice & LibreOffice Projets MobilesLogiciels et matriels mobiles Mobiles Android iOS Windows Phone SystmesLogiciels et matriels systmes Systmes Windows Linux Scurit Hardware Mac Raspberry Pi Rseau Green IT Systmes Embarqus Virtualisation SGBD 4D Access Big Data DB2 Firebird InterBase MySQL NoSQL PostgreSQL Oracle Sybase SQL-Server ACCUEIL MYSQL FORUM MYSQL F.A.Q MYSQL SOURCES MYSQL TUTORIELS MYSQL OUTILS MYSQL LIVRES MYSQL S'inscrire Aide Quoi de neuf ? Forum Actions Marquer les forums comme lus Bugs & Suggestions Rseau social Groupes Liste des utilisateurs FAQ forum Voir l'quipe du site Blogs Agenda Rgles Blogs Projets Recherche avance Index du forum Bases de donnes MySQL Administration ERROR 6 (HY000): Error on delete + Rpondre la discussion Discussion: ERROR 6 (HY000): Error on delete Outils de la discussion Afficher une version imprimable S'abonner cette discussion… Affichage Mode linaire Choisir le mode hybride Choisir le mode arborescent 13/12/2010,16h59 #1 _Agrid Membre rgulier Inscrit ennovembre 2008Messages93Dtails du profilInformations personnelles :ge : 42Localisation : France, Bouches du Rhne (Provence Alpes Cte d'Azur)Informations forums :Inscription : novembre