[mythtv-users] Fresh install from scratch, mysql "No Database Selected" error

[ray cielencki]

# mysql -uroot mysql
(the space between -u and root doesn't matter, but you need a space 
between root and mysql [to select the mysql table that holds access 
privledges])

mysql> UPDATE user SET Password=PASSWORD('ROOT_PWD') WHERE user='root';
mysql> FLUSH PRIVILEGES;
mysql> quit

/rayc

>Just reinstalled from the OS up. A Couple of puzzling
>isses, the most current being mysql. When I follow
>Jarod's documentation I get the following:
>
>[root at PVRBACKEND01 mythtv]# mysql -u rootmysql
>Welcome to the MySQL monitor.  Commands end with ; or
>\g.
>Your MySQL connection id is 1 to server version:
>3.23.58
>
>Type 'help;' or '\h' for help. Type '\c' to clear the
>buffer.
>
>mysql> UPDATE user SET Password=PASSWORD('password')
>WHERE user='root';
>ERROR 1046: No Database Selected