[mythtv-users] mysql setup help

2004-12-28 Thread Tim Krueger
Any help would be great for help setting up mysql 
thanks


[EMAIL PROTECTED] tgkspike]$  # /sbin/chkconfig mysql on
[EMAIL PROTECTED] tgkspike]$ # /etc/init.d/mysql start
[EMAIL PROTECTED] tgkspike]$ # mysql -u root mysql
[EMAIL PROTECTED] 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 
_
[EMAIL PROTECTED] tgkspike]$ su
Password:
[EMAIL PROTECTED] tgkspike]#  # /sbin/chkconfig mysql on
[EMAIL PROTECTED] tgkspike]# # /etc/init.d/mysql start
[EMAIL PROTECTED] tgkspike]# # mysql -u root mysql
[EMAIL PROTECTED] tgkspike]# mysql
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)
[EMAIL PROTECTED] tgkspike]#
___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users


Re: [mythtv-users] mysql setup help

2004-12-28 Thread 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

[EMAIL PROTECTED] tgkspike]$  # /sbin/chkconfig mysql on
[EMAIL PROTECTED] tgkspike]$ # /etc/init.d/mysql start
[EMAIL PROTECTED] tgkspike]$ # mysql -u root mysql
[EMAIL PROTECTED] 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 
_
[EMAIL PROTECTED] tgkspike]$ su
Password:
[EMAIL PROTECTED] tgkspike]#  # /sbin/chkconfig mysql on
[EMAIL PROTECTED] tgkspike]# # /etc/init.d/mysql start
[EMAIL PROTECTED] tgkspike]# # mysql -u root mysql
[EMAIL PROTECTED] tgkspike]# mysql
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)
[EMAIL PROTECTED] tgkspike]#
 


___
mythtv-users mailing list
mythtv-users@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
___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users