Can't access MySQL server, don't know the password of a root account - TagMerge

Can't access MySQL server, don't know the password of a root account

Asked 1 years ago

6

1 answers

Start (first stop the running one) your MySQL in safemode with skiped grant tables eg.:

safe_mysqld --user=mysql --skip-grant-tables --skip-networking

Thereafter you should have access to your database without password and could create a new user/password.

Source: link

Write an answer

Can't access MySQL server, don't know the password of a root account

Debian 10 MariaDB 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'

ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (111)

'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111 "Connection refused")'

error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' -- Missing /var/run/mysqld/mysqld.sock

Docker - Can't access Django server

I can't access to mySQL with node js anymore

The function can't be unconditionally invoked because it can be 'null'. The '!' will have no effect because the receiver can't be null

Can't connect to local MySQL server through socket homebrew

Can't access the Django server at http://127.0.0.1:8000/

Can't create test file lower test start server mysql

python AsyncHTMLSession: You don't have permission to access "XXX" on this server

don't know why but somehow substr() doesn't work in code??(php)

I can't slove this problem. My npx create-react-app and npm start don't work

I don't understand why this program don't compile

The instance member 'params' can't be accessed in an initializer

How do I write a script to reboot a list of servers, but will EXCLUDE servers I don't want rebooted?

nodejs express reconnect mysql ER_ACCESS_DENIED_ERROR: Access denied for user ''@'localhost' (using password: NO)

Laravel Access denied for user 'root'@'localhost' (using password: YES) in laravel 4.2

ModuleNotFoundError: Module not found: Error: Can't resolve 'next/server'

Recent Questions on mysql

Programming Languages