[mythtv-users] mysql setup help
junk_inbox at comcast.net
junk_inbox at comcast.net
Tue Dec 28 20:33:47 UTC 2004
Tim,
From a fellow MythTV Newbie... The "#" marks mean you have to execute the commands as ROOT. To do this, type "su", then enter the ROOT password and your prompt will change from a "$" to a "#". (By entering the "#" marks, you've made them comments...)
If the command listed in Jarod's guide is preceded by a "$", it needs to be executed as your 'mythtv' user, otherwise if it's preceded with a "#" as 'root' via the method above.
Here's an example of what it should look like:
[tgkspike at localhost tgkspike]$ su
Password:
[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.
<etc...>
To get back to your 'regular' userid, type 'exit' at the # prompt, and you'll be returned to yourlocal user account again:
[tgkspike at localhost tgkspike]# exit
[tgkspike at localhost tgkspike]$
Jeff
> 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
>
More information about the mythtv-users
mailing list