[mythtv-users] mysql setup help

Tim Krueger tgkspike at gmail.com
Tue Dec 28 20:05:22 UTC 2004


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]#


More information about the mythtv-users mailing list