SOLVED After imaging the OS, an error came in saying cannot access database

  • After fixing the network PXE booting problem, I came into another issue here. While installing the fog server to my ubuntu 18, I did not enter any password when asking me about the password for mysql. So right now I cannot access mysql and it gave me the error that ‘Access denied for user ‘root@localhost’ (using password:NO)’ So after finishing the image, an error came in saying something wrong because of the denied database. Is there any solution for this? Right now when I enter mysql command, I came to a MariaDB instead of mysql.

  • @Sebastian-Roth Hi Sebastian, I reboot the system and now when I enter the command, it prompted ‘Enter password’, I just click enter and now the error came
    ’ERRO 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: NO). Because last time I entered some command I found in the internet, I did not want that to influence our process so I reboot. Last time, I restarted MySQL and entered ’ sudo mysqld_safe -skip-grant-tables’

  • Senior Developer

    @weidongyan So you can login to the database with just hitting ENTER? (empty password)

    Don’t worry about the naming. Earlier versions were called MySQL and now it’s MariaDB but it’s essentially the same.

  • @Sebastian-Roth Hi Sebastian, when I enter the command, I directly went to the MariaDB instead of MySQL

  • Senior Developer

    @weidongyan MariaDB is kind of the successor of MySQL. But still you see the old name around even if you actually have MariaDB installed - e.g. the command line tools.

    So when you try connecting on the command line: mysql -u root -p and then just hit ENTER for empty password. What happens?

    Please read the following topic: