mysql doesnt ask for username and password

Hello

I have just gained access to a server with a hosting company which has mysql preinstalled. I've only used a server where I have installed mysql myself. On this server i can type mysql at the command line and it will open without needing a username or password. Looking at the mysql. users table there are several users including 2 root users (with different hosts, one is localhost and one is something else). I dont know the root passwords as I didn't create them.

Is it running in safe mode without password protection? If so, how do i tell?

Do i need to change the root password as described here?

http://www.linuxhomenetworking.com/wiki/index.php/Quick_HOWTO_:_Ch34_:_Basic_MySQL_Configuration#.UuKwyNLFJCI

i.e change the root password and then restart the service in normal mode?

Sorry for asking, I'm just a bit nervous about doing it

thanks in advance

andieje

Asked: 2014-01-24

Advertise Here

MySQL Server

1 Solution

LVL 84

Dave BaldwinFixer of ProblemsCommented: 2014-01-24

I've never heard of that exactly but I have worked with a couple of hosting companies that will automatically log you into your own phpMyAdmin when you are already logged into your account.

LVL 24

johanntagleCommented: 2014-01-24

Check also if you have a .my.cnf file in your home directory. I once encountered a server that had the username and password stored there. The mysql client looks for that file if you didn't enter complete credentials.

LVL 84

Dave BaldwinFixer of ProblemsCommented: 2014-01-24

If this is a completely new installation of MySQL, it might still have anonymous users with no user name or password. Those should be deleted if they are still there.
http://dev.mysql.com/doc/refman/5.1/en/default-privileges.html

andiejeAuthor Commented: 2014-01-25

the my.cnf file just has the max number of connections set to 500 and log_slow_queries. There is nothing else in the file. As mentioned in the question there are several users in mysql.users table. There are 2 root users - one at localhost and one at something which appears to be the hosting company. There are 10 users in total, all of which appear to have encrypted passwords. I presume this means the anonymous user has gone?

I am not logging in via phpmyadmin. I am ssh into the server and then when i type mysql at the command line it just opens and you can access the databases therein. There are 9 databases including the mysql one, I dont know what these are but I havent made them.

I've never seen this before

andiejeAuthor Commented: 2014-01-25

Is this because i am logged into ssh as root? i've always been root before and had to give mysql a username and password. If i type mysql -u root -p mysql it will ask me for a password but if i just type mysql it starts the database anyway

andiejeAuthor Commented: 2014-02-01

that was it

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Expand your skills with this month's free Premium course.

mysql doesnt ask for username and password

Join & Write a Comment Already a member? Login.

Featured Post