Mac Os X Error 1045 (28000): Access Denied For User 'root'@'localhost' (using Password: Yes)3/17/2019 Accessing MySQL on a Mac To use MySQL, everything is done in the Terminal, under Applications > Utilities > Terminal. Once Terminal is loaded, create an alias for MySQL. Apr 27, 2014 - “ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)”. [Mac OS X] Unable to move/empty files from Trash. I recently installed the latest version of MySql. I tried to set a password in terminal using the steps shown below. However, I get the error message below. Welcome to Darwin! [localhost:~] helpprob% alias mysql=/usr/local/mysql/bin/mysql [localhost:~] helpprob% mysql -u root -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) [localhost:~] helpprob% Maybe terminal wants me to type my previous sql password. If so,I don't remember what is is. I would appreciate any help. Thank you for your response. I tried your suggestion. I know nothing about using the terminal. I entered 'mysqladmin -password ' without any changes and got this, tcsh: 'Missing name for redirect.' Then I tried putting a new password in the and got the same error message. I tried using a new password without the, but in that place and got this message: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'helpproblem'@'localhost' (using password: YES)' I also read the documentation and tried what that suggests and I keep getting: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'helpproblem'@'localhost' (using password: YES)' I just haven't been able to solve this. ![]() I would appreciate further help. See the MySQL document: The document says 'Log on to your system as. The Unix root user'. But on MacOSX you can't do this. Thank you for the directions. I thought I had it because I got this in the terminal: [localhost:~] root# mysqld_safe --init-file=~/mysql-init & [1] 6514 [localhost:~] root# Starting mysqld daemon with databases from /usr/local/mysql/data STOPPING server from pid file /usr/local/mysql/data/localhost.pid 080207 12:54:06 mysqld ended Then I entered mysql -u root -p, to see if it would take my new password. When I entered the password I got this: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61). So I am still lost. I'm having access problems with MySQL too and I'd like to follow the instructions to reset permissions as you outlined BUT I can hardly begin because I can't seem to shut down the server from the terminal. I tried the sudo kill command in your post but am getting a cat permission denied message and usage message. I've also tried the following to shut down the server: sudo /Library/StartupItems/MySQLCOM/MySQLCOM stop but when i check if it's worked, ps xa| grep mysqld it looks like a process is still running. I've been struggling with my 'access denied for user 'root'@'localhost'.' Error message for awhile and really can't wait to get MySQL up and running so any help would be much much MUCH appreciated. (PS In case you couldn't tell I am new to Macs and terminal). Apple Footer • This site contains user submitted content, comments and opinions and is for informational purposes only. Apple may provide or recommend responses as a possible solution based on the information provided; every potential issue may involve several factors not detailed in the conversations captured in an electronic forum and Apple can therefore provide no guarantee as to the efficacy of any proposed solutions on the community forums. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |