Enter the password and you are off and running. That being the case, you were not logged in as You will have to be explicit in specifying the root user mysqldump -uroot -p -all-databases -routines > all.sql I see you did not specify the user and password. When you did this mysqldump -all-databases -routines > all.sql You should run this command: SHOW GRANTS FOR SHOW VIEW is not there, that's the reason why. LOCK TABLES (If you use an explicit -lock-tables).TRIGGER (If any table has one or more triggers).In that post I show these minimum privileges for a mysqldump I wrote about this Dec 2013 : Which are the minimum privileges required to get a backup of a MySQL database schema? You need to have the SHOW VIEW privilege. Update 3 mysql> SELECT COUNT(1) MySQLGrantsCount,VERSION() MySQLVersion FROM information_lumns WHERE table_schema='mysql' AND table_name='user' Update 2 $ mysql -ANe"SELECT USER(),CURRENT_USER()" | GRANT USAGE ON *.* TO IDENTIFIED BY PASSWORD '.striped.' | The user is the definer of view hdcn.hdkien (and the SQL SECURITY is DEFINER. | GRANT ALL PRIVILEGES ON *.* TO IDENTIFIED BY PASSWORD '.striped.' WITH GRANT OPTION | I run mysqldump with user mysql> show grants for Grants for | Why I got the error when running mysqldump and how can I resolve it? MySQL version: mysql-community-server-5.5.86_64.User 192.168.12.197 has already had the privilege to select on table hdcn_hd and I can select from view hdkien without problem. Hdkien is a view CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `hdcn`.`hdkien` AS (.striped.) Mysqldump: Couldn't execute 'show table status like 'hdkien'': SELECT command denied to user for column 'id' in table 'hdcn_hd' (1143) mysqldump -all-databases -routines > all.sql User-Agent Mozilla/5.0 (Macintosh U PPC Mac OS X 10_5_6 en-us) AppleWebKit/526.11 (KHTML, like Gecko) Version/4.0dp1 Safari/526.11.2Īccept text/xml,application/xml,application/xhtml xml,text/html q=0.9,text/plain q=0.8,image/png,*/* q=0.When using mysqldump to backup MySQL, I got following error. URI /webwork2/Testing2/instructor/setmaker/ In WeBWorK::ContentGenerator::go called at line 353 of /opt/webwork/webwork2/lib/WeBWorK.pm In WeBWorK::ContentGenerator::content called at line 194 of /opt/webwork/webwork2/lib/WeBWorK/ContentGenerator.pm ![]() In WeBWorK::Template::template called at line 490 of /opt/webwork/webwork2/lib/WeBWorK/ContentGenerator.pm In WeBWorK::ContentGenerator::Instructor::SetMaker::body called at line 152 of /opt/webwork/webwork2/lib/WeBWorK/Template.pm ![]() ![]() In WeBWorK::Utils::Tasks::renderProblems called at line 1309 of /opt/webwork/webwork2/lib/WeBWorK/ContentGenerator/Instructor/SetMaker.pm In WeBWorK::PG::new called at line 262 of /opt/webwork/webwork2/lib/WeBWorK/Utils/Tasks.pm In WeBWorK::PG::Local::new called at line 52 of /opt/webwork/webwork2/lib/WeBWorK/PG.pm The information below can help locate the source of the problem. We select an NPL Problem Direectory, such as 270/setDerivatives6InverseTrig, and click the "View Problems" button then get the following httpd-error.log entry: Invalid offset: MDT\n * in WeBWorK::PG::Local::new called at line 52 of /opt/webwork/webwork2/lib/WeBWorK/PG.pm\n * in WeBWorK::PG::new called at line 262 of /opt/webwork/webwork2/lib/WeBWorK/Utils/Tasks.pm\n * in WeBWorK::Utils::Tasks::renderProblems called at line 1309 of /opt/webwork/webwork2/lib/WeBWorK/ContentGenerator/Instructor/SetMaker.pm\n * in WeBWorK::ContentGenerator::Instructor::SetMaker::body called at line 152 of /opt/webwork/webwork2/lib/WeBWorK/Template.pm\n * in WeBWorK::Template::template called at line 490 of /opt/webwork/webwork2/lib/WeBWorK/ContentGenerator.pm\n * in WeBWorK::ContentGenerator::content called at line 194 of /opt/webwork/webwork2/lib/WeBWorK/ContentGenerator.pm\n * in WeBWorK::ContentGenerator::go called at line 353 of /opt/webwork/webwork2/lib/WeBWorK.pm and the following web page error details: Error messages The nf file has the only reference to "MDT" that we know of:
0 Comments
Leave a Reply. |