[BlueOnyx:19164] Re: default Password for MySql

[Chris Gebhardt - VIRTBIZ Internet]

On 2/22/2016 12:55 PM, Richard Barker wrote:
> Hey Mixhael,
> I found all that and use the password it showed me
> but still does not work
> Â Stil get error
>
> mysqlshow: Access denied for user 'root'@'localhost' (using password: YES)
> I did a service mysqld restart and aservice mysqld stop and service
> mysqld start

So if you're trying mysql -p, then entering the correct password, and 
it's not working, you may need to reset manually as I mentioned in 
[BlueOnyx:19159].

First, stop the daemon, which on 5209R is MariaDB:
# systemctl stop mariadb

Then start the service without password:
  # mysqld_safe --skip-grant-tables &

Enter into MariaDB / MySQL:
  # mysql -u root

Set the new password:
mysql> use mysql;
mysql> update user set password=PASSWORD("NEW-ROOT-PASSWORD") where 
User='root';
mysql> flush privileges;
mysql> quit

Stop the service:
# systemctl stop mariadb

Restart the service
# systemctl start mariadb

Then you should be able to access with the "NEW-ROOT-PASSWORD" that you set.

More info at 
http://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html

-- 
Chris Gebhardt
VIRTBIZ Internet Services
Access, Web Hosting, Colocation, Dedicated
www.virtbiz.com | toll-free (866) 4 VIRTBIZ