Personal Summary-mysql Error

Error problem:

650) this.width=650; "src="/e/u261/themes/default/images/spacer.gif "border=" 0 "style=" Background:url ("/e/u261/ Lang/zh-cn/images/localimage.png ") no-repeat center;border:1px solid #ddd;" alt= "Spacer.gif"/>650) this.width=650 ; "Src=" Http://s3.51cto.com/wyfs02/M00/7F/32/wKiom1cWKBHj0-_NAAAYxUpJE54946.png "title=" 89119a3b-c75f-4243-95db-f0932433112c.png "alt=" Wkiom1cwkbhj0-_naaayxupje54946.png "/>

Solve:

Mysql> Grant execute on procedure state.proc_order_seller to ' kfdata ' @ ' localhost ';

Query OK, 0 rows Affected (0.00 sec)

mysql> flush Privileges;

Query OK, 0 rows Affected (0.00 sec)

Error problem: Mysqldump:got error:1227:access denied; Need (at least one's) the RELOAD privilege (s) for this operation when doing refresh

Workaround: Insufficient permissions, use root backup

failure Problem: mysqldump-uroot-p ' 123456 '-f-b-a|gzip >/data/mysql/backup/mysqlbak_$ (date +%f). sql.gz

--warning:skipping The data of table mysql.event. Specify the--events option explicitly.

Mysqldump:got error:1146:table ' test.aa ' doesn ' t exist when using LOCK TABLES

Solve:

Delete the aa.frm file in the/application/mysql/data/test/directory

Error: MySQL error synchronizing from library data

FIX: The method of skipping error prompts from the Library settings:

Stop slave;
Set global sql_slave_skip_counter = 1;
Start slave;

This article is from the "Linux operations self-cultivation" blog, please be sure to keep this source http://ywliyq.blog.51cto.com/11433965/1765520

Personal Summary-mysql Error