Take the 2-minute tour ×
Ask Ubuntu is a question and answer site for Ubuntu users and developers. It's 100% free, no registration required.

When dist-upgrading Ubuntu 11.10 to 12.04 UpdateManager asked to enter a "new" user password for MySQL. I denied 3 times. This asking was put misleadingly. I better should have entered a user password for me for the »MyQSL« privilege system, as I know now.

Now my database »mysql« > table »user« does not shows a password entry for me. I can do most administrative tasks on my MySQL database though. I feel that this is a security gap. I'd like closing it.

I entered a password. But now I cannot access my MySQL server through my LibreOffice Base frontend any more: "Access denied." How to rconcile both requirements?

share|improve this question

1 Answer 1

This is rather ambiguous, you need to provide more detail:

1) The new password that the system asked you about: Which application asked you for it? was that MySQL server or was it Base? 2) "I denied 3 times" does that mean you entered it wrong multiple times? 3) "Now my database »mysql« > table »user« does not shows a password entry for me". Does that mean that:

SELECT Password FROM mysql.user;

returns empty for your user. Is that the root user?

4) You seem to be able to connect in some other way that is not using Base. What is that?

I will answer wabout what I did as I had a similar problem:

First, users updating Ubuntu and using Base should make sure Java classpath is stored correctly, if not try:

sudo apt-get install libmysql-java

Then, my second issue was that the MySQL user actually dissapeared. For this I just created it again using phpmyadmin. Restarted sql and run Base. Note that Base remembered the user I previously had.

share|improve this answer
    
quinestor wrote: –  user43816 May 30 '12 at 6:33

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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