Ask Ubuntu is a question and answer site for Ubuntu users and developers. It's 100% free.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm trying to install queXS cati app on my Ubuntu desktop and I installed MySQL server and PHP 5 and I cannot login into MySQL server as root without password:

mysql -u root 

it says

ERROR 1045(28000) : Access denied for user 'root@localhost' (using password: no )

But it's okay when I enter mysql -u root -p

I can't figure out what the problem is.

share|improve this question
5  
Try this: mysql -u root -p mysql Enter password: and you will get: mysql> – user273774 Apr 24 '14 at 18:47

That is the normal behaviour. You set a root password for your database so from now on you can't access it without password. That is why it reports:

Access denied for user 'root@localhost' (using password: no )

Obviously when you give the password with the -p switch you succeed.

share|improve this answer

In simple words your "root" session do not know password to mysql root user.

If you want to make easier to access your mysql

create .my.cnf in /root/

and put in it

[mysqladmin]
 user = root
 password = mysqlrootpassword
[mysql]
 user = root
 password = mysqlrootpassword
[mysqldump]
 user = root
 password = mysqlrootpassword

where offcourse mysqlrootpassword is your password for mysql's root password so when you execute mysql it uses this password

Remeber about safety of this file - put secure rights, so nobody on your server can read it!

share|improve this answer
1  
It's bad to encourage others to put root passwords plaintext on disk. By deduction, that badness property propagates to the person doing it. – Eric Leschinski Dec 31 '15 at 11:49

Login to webmin and under servers, access the mySQLdatabase server.You will then be able to set the (user) password provided you have:

mysql -u (**user**) -p < /usr/share/doc/rsyslog-mysql-5.8.10/createDB.sql.

The web gui is easy but to be secure use the terminal.

cheers.

share|improve this answer
    
do not exists /usr/share/doc/rsyslog-mysql-5.8.10/createDB.sql. – Vitor Mazuco Sep 14 '15 at 15:59

protected by Community Dec 4 '14 at 13:50

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site.

Would you like to answer one of these unanswered questions instead?

Not the answer you're looking for? Browse other questions tagged or ask your own question.