V
V
vVedik2014-02-09 00:47:17
MySQL
vVedik, 2014-02-09 00:47:17

Can't connect to MySQL database on Mac OS without root privileges?

MySQL server is enabled
when using the MacBook-Air command: / Vladimir$ mysql -u root -p
Enter password: I enter the password, it
gives an error
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
what to do Don't know

Answer the question

In order to leave comments, you need to log in

1 answer(s)
V
vVedik, 2014-02-09
@vVedik

found a solution)))))))))
1) Turned off the MySQL server
2) Went into the cd /usr/bin folder
3) Launched the daemon with parameters in the command line:
sudo mysqld_safe --skip-grant-tables
4) mysql
5) mysql> use mysql;
mysql> UPDATE user SET password=PASSWORD('new_password_here') WHERE user = 'root';
mysql> exit;
6) Started MySQL server

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question