Topic: Logging in to mysql

[Jens F.]

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

[thorsten greiner]

hi...

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



greetinx,
thorsten

[Jens F.]

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

[Dan Brown]

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.

[Jens F.]

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

[Dan Brown]

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.

[Alejandro]

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

[thorsten greiner]

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

[Beno]

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.