LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 02-03-2007, 04:52 PM   #1
Umagarz
LQ Newbie
 
Registered: Dec 2006
Location: Annisse (Denmark)
Distribution: Ubuntu
Posts: 9

Rep: Reputation: 0
mySQL problems while installing Mythtv


Hi...

while installing Mythtv, a message came up:

Failed to connect to database: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) 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
tobias@TBK-Ubuntu-Laptop:~$

It says something with an invalid password or username, but I haven't set any username or password for mySQL.
mySQL is not my cup of tea...

can somebody help me?

Last edited by Umagarz; 02-03-2007 at 04:57 PM.
 
Old 02-03-2007, 09:14 PM   #2
tbutttbutt
Member
 
Registered: Jan 2006
Location: India
Distribution: Fedora 7, Linuxfromscratch 6.2
Posts: 66

Rep: Reputation: 15
You have to set up a root and user password first:

mysqladmin -u root password 'root password'

(this will be the mysql root password for mysql administration)

Then set up a user:
Run the mysql client
mysql -u root

Now in the client enter something like:
grant all on db_name to umagarz@localhost identified by 'user password';
quit
(enter the name of the database you have created in place of db_name)
If you haven't created a database yet you can do that first with:
create db_name;

Now you will have a mysql user accout with the password you entered.

You can start the mysql client now with:
mysql -p <db_name>

Be sure to enter your username and password in any script with which you connect to the mysql server.
 
  


Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
MythTV MySQL error?? itz2000 Linux - Software 5 06-16-2006 05:27 AM
how to setup mysql for mythtv?? jadukor Slackware 9 04-13-2006 01:01 AM
MythTV - problems installing qt-mysql paulmai Linux - Software 0 03-06-2006 04:52 AM
mythtv and mysql noob problems Shaun32 SUSE / openSUSE 1 05-09-2005 02:48 PM
MythTV & mySQL mykrob Linux - Software 14 01-28-2005 01:13 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 12:30 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration