What is mysql password? [SOLVED]

Questions about applications and software
Forum rules
Before you post please read how to get help

What is mysql password? [SOLVED]

Postby aqeeliz on Wed Mar 12, 2008 12:13 pm

This sounds like a stupid question, but I can't figure out the mysql password. As far as I know, by default there is no password. I have installed mysql from default repos, on Daryna KDE edition.

Any help will be much appreciated.
Last edited by aqeeliz on Tue Mar 25, 2008 7:18 am, edited 1 time in total.
aqeeliz
Level 1
Level 1
 
Posts: 5
Joined: Tue Mar 04, 2008 6:40 pm

Linux Mint is funded by ads and donations.
 

Re: What is mysql password?

Postby Husse on Wed Mar 12, 2008 5:49 pm

It was some time since I used mysql and in Windows, but I think admin - admin for name and pass - this is something you easily find in the mysql web site
Image
Don't fix it if it ain't broken, don't break it if you can't fix it
Husse
Level 21
Level 21
 
Posts: 19703
Joined: Sun Feb 11, 2007 7:22 am
Location: Near Borås Sweden

Re: What is mysql password?

Postby aqeeliz on Thu Mar 13, 2008 1:23 am

According to mysql websites, default user is root with no password, which is not working for me. A google search told me that it is possible that some distro may change default username / password of mysql, apparently, which is not the case here. I would check if I am doing something else wrong.
aqeeliz
Level 1
Level 1
 
Posts: 5
Joined: Tue Mar 04, 2008 6:40 pm

Re: What is mysql password?

Postby aqeeliz on Sun Mar 16, 2008 12:38 pm

After trying for couple of days, I still can't solve the problem. Here are the details:

Code: Select all
$ sudo mysql_install_db
Installing MySQL system tables...
OK
Filling help tables...
OK

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h localhost password 'new-password'
See the manual for more instructions.
You can start the MySQL daemon with:
cd /usr ; /usr/bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl
cd mysql-test ; perl mysql-test-run.pl

Please report any problems with the /usr/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at http://shop.mysql.com
$ sudo /usr/bin/mysqld_safe
mysqld_safe[16038]: A mysqld process already exists
$ mysqladmin -u root password 'newpass'
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
$ sudo mysqladmin -u root password 'newpass'
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
$ sudo su -
There will be big changes for you but you will be happy.
# mysqladmin -u root password 'newpass'
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
# mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)


I have tried using other using other username / password combinations, like mysql / mysql, admin / admin etc. I also tried to reset mysql password using tip mentioned at http://www.mydigitallife.info/2006/04/2 ... ql-server/ but that didn't help either.
aqeeliz
Level 1
Level 1
 
Posts: 5
Joined: Tue Mar 04, 2008 6:40 pm

Re: What is mysql password?

Postby newfy78 on Mon Mar 24, 2008 1:33 pm

when you first installed mysql it should have asked you to set the root password. You can also change the root password from the mysql command line (although that will be hard to do if you don't know the current password).

I would just re-install mysql and set it up again.

I have instructions on setting up your mysql in a newbie guide to Daryna:

http://linuxmint.com/forum/viewtopic.php?f=90&t=10664

My document is assuming you are trying to setup a database for Amarok but you can ignore those parts (i.e. don't create the database called "amarok").
newfy78
Level 1
Level 1
 
Posts: 12
Joined: Thu Mar 20, 2008 5:43 pm

Re: What is mysql password?

Postby aqeeliz on Tue Mar 25, 2008 6:38 am

Thanks for the link.

I have already followed all those steps and tried un-install and then re-installing mysql, but it didn't work.
I got it working by resetting the root password, though I have misplaced the url, would post it here when I will find it.
aqeeliz
Level 1
Level 1
 
Posts: 5
Joined: Tue Mar 04, 2008 6:40 pm


Return to Software & Applications

Who is online

Users browsing this forum: Google Adsense [Bot] and 12 guests