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. PGA -- 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
