Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

How can I set mysql root password in a new installation?

I've just installed mysql server on Fedora 24 and I tried to secure it by mysql_secure_installation command but a password is required even if I never set a password for root user. I obviously cannot access mysql as a password is required. I downloaded mysql with YUM I know on OS X a temporary password is set but here ? Msql install documentation for Fedora don't speak about a temporary password It seems.

Why it happens? How i can reset/set mysql root password ?

Access without password is not accepted:

[root@localhost ~]# mysql_secure_installation

Securing the MySQL server deployment.

Enter password for user root: Error: Access denied for user 'root'@'localhost' (using password: NO)

click to hide/show revision 2
No.2 Revision

updated 2016-10-25 06:40:20 -0500

hhlp gravatar image

How can I set mysql root password in a new installation?

I've just installed mysql server on Fedora 24 and I tried to secure it by mysql_secure_installation command but a password is required even if I never set a password for root user. I obviously cannot access mysql as a password is required. I downloaded mysql with YUM I know on OS X a temporary password is set but here ? Msql install documentation for Fedora don't speak about a temporary password It seems.

Why it happens? How i can reset/set mysql root password ?

Access without password is not accepted:

[root@localhost ~]# mysql_secure_installation

mysql_secure_installation

Securing the MySQL server deployment.

deployment.

Enter password for user root: Error: **Error: Access denied for user 'root'@'localhost' (using password: NO)

NO)**