Power Developer
https://powerdeveloper.org/forums/

How to configure MySQL On ubuntu
https://powerdeveloper.org/forums/viewtopic.php?f=31&t=689
Page 1 of 1

Author:  magnetic [ Fri Jul 28, 2006 11:10 pm ]
Post subject:  How to configure MySQL On ubuntu

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
:?:

Author:  ironfist [ Sat Jul 29, 2006 4:24 am ]
Post subject: 

Try using PHPMyAdmin. Sure, it's overkill to install Apache
just to config MySQL, but I'm no MySQL Guru..

Author:  heinrich.lehmann [ Sat Jul 29, 2006 8:08 am ]
Post subject:  Configuring MySQL

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 !

Author:  magnetic [ Sat Jul 29, 2006 11:42 am ]
Post subject: 

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

Author:  ironfist [ Sun Jul 30, 2006 3:21 am ]
Post subject: 

Yes, default pass for MySQL are root/nothing.

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

Page 1 of 1 All times are UTC-06:00
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/