On Mon, May 14, 2007 4:34 pm, Paul G. Allen wrote: > 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. >> >
Yes, I plan to get to it. -- Lan Barnes SCM Analyst Linux Guy Tcl/Tk Enthusiast Biodiesel Brewer -- [email protected] http://www.kernel-panic.org/cgi-bin/mailman/listinfo/kplug-list
