0

I tried

sudo dpkg-reconfigure mysql-server-5.5

I got this windows to allow me to reset my root password

enter image description here

How long should I wait after re-enter the confirmed password ?

Should I wait until it finished ?

As of now, I almost 2 mins :

Result in CLI

sudo dpkg-reconfigure mysql-server-5.5

170227 18:05:25 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
170227 18:05:25 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.
170227 18:05:25 [Note] /usr/sbin/mysqld (mysqld 5.5.54-0ubuntu0.14.04.1) starting as process 11343 ...

After about 5 mins I got this screen

enter image description here

How do I fix it ?

Do I need to do anything to gain access back into my mysql as root ?

Community
  • 1
code-8
  • 205

1 Answers1

1

Installing and uninstalling mysql won't remove your database. If you have a database it'll use what is there.

If you purge mysql and rename or remove the mysql configuration files you'll have an opportunity to perform a fresh install of mysql, whereas you can use a new password.

You have to have the password to access your current mysql database.

You asked Do I need to do anything to gain access back into my mysql as root ?. The answer is yes.

You can change the password by running steps provided in this answer:
mysql doesn't ask for root password when installing

Community
  • 1
L. D. James
  • 25,444