137 reputation
6
bio website favadi.com
location Hanoi, Vietnam
age 26
visits member for 2 years, 10 months
seen 10 hours ago

Nemo


Sep
10
awarded  Popular Question
Apr
18
accepted Problem with mysqldump and view
Apr
18
comment Problem with mysqldump and view
Silly me. I found out the real problem. Somehow, I have a clone of db hdcn (name hdcn_old). And the problem is user tungbt@192.16.12.179 do not have the correct privileges on this db. The error line (as I post above) do not have the db name, so I assume the error occur when dumping hdcn db. Sorry for wasting your time.
Apr
17
comment Problem with mysqldump and view
see the output on my new update.
Apr
17
revised Problem with mysqldump and view
added 373 characters in body
Apr
17
comment Problem with mysqldump and view
See my update. I surely run mysqldump with root@localhost. I have the same problem as the reporter in bug:70907. I have upgraded MySQL from 5.1 to 5.5 one month ago. How to know if I have run mysql_upgrade properly or not?
Apr
17
revised Problem with mysqldump and view
added 173 characters in body
Apr
17
comment Problem with mysqldump and view
That's not the case. I specify my username and password in ~/.my.cnf. I try with -u and -p for mysqldump as you said above and have the same error.
Apr
17
comment Problem with mysqldump and view
See my update. The user root@localhost and tungbt@192.168.12.197 both have had the SHOW VIEW privilege already.
Apr
17
revised Problem with mysqldump and view
added 1851 characters in body
Apr
16
comment Problem with mysqldump and view
@dwjv yes, for sure.
Apr
16
asked Problem with mysqldump and view
May
9
accepted EMS SQL manager permission problem
May
8
comment EMS SQL manager permission problem
Maybe you misunderstood my question a bit. I do not see the relationship between your answer to my problem. All I want to do is editing a stored procedure? Why EMS SQL Manager need those permissions? You can see my new update for more information.
May
8
revised EMS SQL manager permission problem
added 1481 characters in body
Mar
8
asked EMS SQL manager permission problem
Nov
6
awarded  Scholar
Nov
6
accepted Failed to restore mysql database with zmanda
Jul
24
awarded  Editor
Jul
24
revised Failed to restore mysql database with zmanda
deleted 4 characters in body