Forgot: Additional info on GRANT: http://dev.mysql.com/doc/refman/5.0/en/grant.html
(Assuming the use of MySQL 5.x. For earlier versions, use the manual for that version.) PGA On Mon, 2007-05-14 at 16:20 -0700, Paul G. Allen wrote: > On Mon, 2007-05-14 at 16:11 -0700, Lan Barnes wrote: > > > > > I hate to come running back to daddy, but ... > > > > [EMAIL PROTECTED] ~]# mysql -u mythtv -p -h localhost mythconverg > > Enter password: > > Reading table information for completion of table and column names > > You can turn off this feature to get a quicker startup with -A > > > > Welcome to the MySQL monitor. Commands end with ; or \g. > > Your MySQL connection id is 6 to server version: 5.0.27 > > > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > > > mysql> GRANT ALL on mythconverg.* to 'mythtv'@'%' IDENTIFIED by 'password'; > > ERROR 1044 (42000): Access denied for user 'mythtv'@'localhost' to > > database 'mythconverg' > > > > Which is why I use the GUI: To eliminate the inevitable syntax errors I > will make on the command line, or to make sure I'm allowed to do what > I'm trying to do with the user I'm doing it with. > > First thing, 'password' is the password that the user mythtv is > configured with (e.g. - the one you used to log in). The single quotes > are delimiters for the password. > > Note also that the user [EMAIL PROTECTED] must have the GRANT privilege > for database mythconverg. > -- Paul G. Allen BSIT/SE Owner/Sr. Engineer Random Logic Consulting www.randomlogic.com -- [email protected] http://www.kernel-panic.org/cgi-bin/mailman/listinfo/kplug-list
