Re: Replication Bug with underscore
Sinisa Milivojevic <[email protected]>
| Newsgroups | gmane.comp.db.mysql.bugs |
|---|---|
| Message-ID | <[email protected]> |
Brian Piere writes: > 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 Hi! What is the MySQL version you are using and are your master and slave running the same version of MySQL ??? The aboe command worked fine as is: [/mnt/work/mysql-4.0]$ ./client/mysql -e "grant all on rintsma_prints.* to 'printsma_brian'@localhost" [/mnt/work/mysql-4.0]$ ./client/mysql -e "show grants for 'printsma_brian'@localhost" +------------------------------------------------------------------------------------------------------------------------------------+ | Grants for printsma_brian@localhost | +------------------------------------------------------------------------------------------------------------------------------------+ | GRANT USAGE ON *.* TO 'printsma_brian'@'localhost' | | GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER ON `rintsma_prints`.* TO 'printsma_brian'@'localhost' | +------------------------------------------------------------------------------------------------------------------------------------+ -- Sincerely, -- For technical support contracts, go to https://order.mysql.com/?ref=msmi __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[email protected]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB /_/ /_/\_, /___/\___\_\___/ Fulltime Developer and Support Coordinator <___/ www.mysql.com Larnaca, Cyprus -- MySQL Bugs Mailing List For list archives: http://lists.mysql.com/bugs To unsubscribe: http://lists.mysql.com/[email protected]