[mythtv-users]Help needed -- cant run setup on Mandrake 9.1,getting qt-MySQL error

Mike Miller miller44 at optonline.net
Sun Jul 6 19:35:36 EDT 2003


Thanks, I think im getting somewhere lol
Ok I did what you said, turns out I do not have a PW set, however when I
did show databases, this is what came up
+-----------+
| Database  |
+-----------+
| mysql     |
| test      |
+-----------+
2 rows in set (0.03 sec)

could this be my problem?
Thanks again

-----Original Message-----
From: mythtv-users-bounces at snowman.net
[mailto:mythtv-users-bounces at snowman.net] On Behalf Of Cedar McKay
Sent: Sunday, July 06, 2003 5:08 PM
To: Discussion about mythtv
Subject: Re: [mythtv-users]Help needed -- cant run setup on Mandrake
9.1,getting qt-MySQL error


On Sunday, July 6, 2003, at 11:39  AM, Mike Miller wrote:

> I did mean it the other way around, however I did not run it w/ -p,
the
> intallation how to says
> Mandrake 9.0 and Red Hat Linux
>
> $ mysql -u root < mc.sql
>
> I extracted that file from the tar, tried again, mysql -u root -p <
> mc.sql and it said enter password, so I typed in my root pass and then
> it said ERROR 1045: Access denied for user: 'root at localhost' (Using
> password: YES)

mysql keeps separate passwords than the rest of your system. So  mysql 
-u root < mc.sql would be correct if you have never manually set a 
password for mysql, and mysql -u root -p < mc.sql would be for if you 
have set a password manually.


I think you are a bit confused. I'll try to help. First figure you 
whether you even have a password set for mysql. Do this:

> % mysql -u root

if no password is set, then you will see the following:

> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 13 to server version: 3.23.53-entropy.ch
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
> mysql>

now type "exit"

If that didn't work try this:
> % mysql -u root -p

and then when prompted use any passwords that you may have set in the 
past. When you hit the right one you will get this:


> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 13 to server version: 3.23.53-entropy.ch
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
> mysql>


Ok, hopefully now you know whether you have a password or not, and if 
you do, what it is. If you do have a password you must use the "-p" 
when giving mysql commands. If you don't have a password, skip the "-p".


So now it is time to go to the database directory and do either:

mysql -u root -p < mc.sql
or
mysql -u root  < mc.sql

depending on whether you have or don't have a password set.

Do not expect any output from this command. If you want to check 
whether you were successful try this:

mysql -u root -p
or
mysql -u root
(again depending)
then once you get a mysql prompt do:
mysql> show databases;

you should see a list of your databases including one called 
"mythconverg" If you have that one you are all set and you can go to 
the next step.


best,
Cedar

_______________________________________________
mythtv-users mailing list
mythtv-users at snowman.net
http://lists.snowman.net/cgi-bin/mailman/listinfo/mythtv-users




More information about the mythtv-users mailing list