Replication Bug with underscore
"Brian Piere" <[email protected]>
| Newsgroups | gmane.comp.db.mysql.bugs |
|---|---|
| Message-ID | <[email protected]> |
When I run SHOW SLAVE STATUS I get the following error....
-----------------
n.005 | 35671 | plain-relay-bin.003 | 12158086 |
server-bin.
003 | Yes | No | |
| 1133 | Error 'Can't find any matching row in the user
table' o
n query 'GRANT ALL ON `printsma\_prints`.* TO 'printsma_brian'@'localhost''.
Def
ault database: 'mysql' | 0 | 14366122 | 540788708
-------------------
The reason the query is failing is because my user name has an underscore in
it. The following query works...
GRANT ALL ON `printsma\_prints`.* TO 'printsma\_brian'@'localhost'
It looks like you are escaping the underscore within the database name but
not within the user name.
Thanks for looking into it
~Brian
--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/[email protected]