[mythtv-users] mysql setup help

[Michael J. Lynch]

Are you typing the "#" signs?  If so, don't.  The pound signs are the
prompt when you are logged in as root user.  Do your "AS ROOT"
stuff but don't type the "#" signs.

Tim Krueger wrote:

>Any help would be great for help setting up mysql 
>thanks
>
>
>[tgkspike at localhost tgkspike]$  # /sbin/chkconfig mysql on
>[tgkspike at localhost tgkspike]$ # /etc/init.d/mysql start
>[tgkspike at localhost tgkspike]$ # mysql -u root mysql
>[tgkspike at localhost tgkspike]$ mysql
>Welcome to the MySQL monitor.  Commands end with ; or \g.
>Your MySQL connection id is 13 to server version: 4.0.20'-Max'
>
>Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
>mysql>  UPDATE user SET Password=PASSWORD('r862536r') WHERE user='root';
>ERROR 1046: No Database Selected
>mysql> FLUSH PRIVILEGES;
>ERROR 1227: Access denied. You need the RELOAD privilege for this operation
>mysql> quit
>Bye
>__________________________________________
>AS ROOT 
>_________________________________________
>[tgkspike at localhost tgkspike]$ su
>Password:
>[root at localhost tgkspike]#  # /sbin/chkconfig mysql on
>[root at localhost tgkspike]# # /etc/init.d/mysql start
>[root at localhost tgkspike]# # mysql -u root mysql
>[root at localhost tgkspike]# mysql
>ERROR 1045: Access denied for user: 'root at localhost' (Using password: NO)
>[root at localhost tgkspike]#
>  
>
>------------------------------------------------------------------------
>
>_______________________________________________
>mythtv-users mailing list
>mythtv-users at mythtv.org
>http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>  
>


-- 
Michael J. Lynch

What if the hokey pokey IS what it's all about -- author unknown