Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: Jens F. on May 08, 2001, 01:09:54 PM

Title: Logging in to mysql
Post by: Jens F. on May 08, 2001, 01:09:54 PM

Hi I try to create a new database in mysql.

I try to log in like this:

mysql -u root -p

with my root password

But it seems that mysql does not except my root password to log in.

Is there a different passwort or user to log in to mysql or where can I find the correct one?

THX

Jens

Title: Re: Logging in to mysql
Post by: thorsten greiner on May 08, 2001, 03:38:19 PM

hi...

your mysql password is in /root/.my.cnf

:)

greetinx,
thorsten

Title: Re: Logging in to mysql
Post by: Jens F. on May 08, 2001, 05:52:19 PM

Thax Thorsten,

but there is no file called /root/.my.cnf

in my root directory.

The only .my.cnf I could my on my pc is in etc/ and this one is empty.

Should I create one? If so how is the structure of the file?

THX

Jens

Title: Re: Logging in to mysql
Post by: Dan Brown on May 08, 2001, 06:11:39 PM

If you're running e-smith 4.1.x, you shouldn't need to enter the mysql root password at all, as it should be stored in /root/.my.cnf.  There should be no /etc/.my.cnf.  I don't know how to go about regenerating the file, though--presumably there's a scripted way to do it, but I don't know what it is.

Title: Re: Logging in to mysql
Post by: Jens F. on May 08, 2001, 06:45:53 PM

I am using 4.1 b3 and I try to install the webcalendar project.

For this reason I have to create the database.

Thanks anyway

Jens

Title: Re: Logging in to mysql
Post by: Dan Brown on May 08, 2001, 06:49:51 PM

Well, first, you should upgrade to 4.1.2 for any number of reasons.  Second, you should find the mysql root password in the ldap.pw file--I think it's in /etc/openldap.

Title: Re: Logging in to mysql
Post by: Alejandro on May 08, 2001, 06:54:38 PM

If you upgrade, to 4.1.2 you mysql password could be regenerated.
Alejandro

Title: Re: Logging in to mysql
Post by: thorsten greiner on May 08, 2001, 07:06:46 PM

needed the password for phpMyAdmin as well... i'm running 4.1.1

---- paste start ----

[root@broadway /etc]# less /root/.my.cnf
#------------------------------------------------------------
# DO NOT MODIFY THIS FILE! It is updated automatically by the
# e-smith server and gateway software. Instead, modify the source
# template in the /etc/e-smith/templates directory. For more
# information, see http://www.e-smith.org.
#
# copyright (C) 1999-2001 e-smith, inc.
#------------------------------------------------------------

[client]
password=xxxxxx


#------------------------------------------------------------
# TEMPLATE END
#------------------------------------------------------------

---- paste end ----

thorsten

Title: Re: Logging in to mysql
Post by: Beno on May 09, 2001, 10:44:31 AM

Dan you always cease to amaze me.

This works no probs...........

Had the same problem trying to get PHP-Nuke to work.

------------you should find the mysql root password in the ldap.pw file
-------------I think it's in /etc/openldap.