All times are UTC-06:00




Post new topic  Reply to topic  [ 5 posts ] 
Author Message
PostPosted: Fri Jul 28, 2006 11:10 pm 
Offline

Joined: Fri Sep 24, 2004 1:39 am
Posts: 269
Location: Los Angeles
Hey guys
I'm trying to configure the MySQL client on my peg box so I can use Mythtv properly but I cant seem to get it right. Can someone plz post a step by step how to??

tia
magnetic
:?:


Top
   
 Post subject:
PostPosted: Sat Jul 29, 2006 4:24 am 
Offline

Joined: Fri Sep 24, 2004 1:39 am
Posts: 429
Location: Secure Networks / Sweden
Try using PHPMyAdmin. Sure, it's overkill to install Apache
just to config MySQL, but I'm no MySQL Guru..


Top
   
 Post subject: Configuring MySQL
PostPosted: Sat Jul 29, 2006 8:08 am 
Offline

Joined: Thu Feb 02, 2006 9:43 am
Posts: 20
Location: Cologne
Hi magnetic
Perhaps you start by telling us what happens when you start what !?
If you have the same problem i had with MySQL on Gentoo/x86 there will be no benefit of apache or PHPmyadmin or whatever.
So you start by writing step-by-step what you did and which answers you got from your system !


Top
   
 Post subject:
PostPosted: Sat Jul 29, 2006 11:42 am 
Offline

Joined: Fri Sep 24, 2004 1:39 am
Posts: 269
Location: Los Angeles
Thanks for the responses guys
Quote:
magnetic@magnetic-desktop:~$ sudo dpkg-reconfigure --force mythtv-database
Failed to connect to database: Access denied for user 'root'@'localhost' (using password: YES) at -e line 5, <> line 1.
Failed to create database (incorrect admin username/password?)
If you supplied incorrect information, try:
dpkg-reconfigure --force mythtv-database
Ok here is my shell output. After the dpkg-recondigure of the mythv database it takes me to the gui to reconfigure and asks me for the admin/user name and the password. It recommends to leave it at "root" and blank for password (default mysql settings?) but then it returns the "Failed to create database"
I havent independently tried to configure the Mysql client as I don't know how.

Hope this makes sense and please help.

magnetic


Top
   
 Post subject:
PostPosted: Sun Jul 30, 2006 3:21 am 
Offline

Joined: Fri Sep 24, 2004 1:39 am
Posts: 429
Location: Secure Networks / Sweden
Yes, default pass for MySQL are root/nothing.

Try:
mysqladmin password <new pass>
mysqladmin create <databasename> -p


Top
   
Display posts from previous:  Sort by  
Post new topic  Reply to topic  [ 5 posts ] 

All times are UTC-06:00


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
cron
PowerDeveloper.org: Copyright © 2004-2012, Genesi USA, Inc. The Power Architecture and Power.org wordmarks and the Power and Power.org logos and related marks are trademarks and service marks licensed by Power.org.
All other names and trademarks used are property of their respective owners. Privacy Policy
Powered by phpBB® Forum Software © phpBB Group