![]() ![]() ![]() Change the password in the 3 following files (this info was culled from the living-e AG forums): Once you have entered that, the MySQL password is changed.Ģ. It will ask for the current password after you hit enter. Applications/MAMP/Library/bin/mysqladmin -u root -p password Open the terminal and type the following: Use command line to change the password (as documented in the MAMP start page FAQ) Only the first is documented in the MAMP start page FAQ, but if you don't do the second then you get an error message when you try to access anything from the MAMP start page.ġ. When you are changing the default user/password from root/root, you need to do two things. If you're connected to the internet, this is a must. The default username/password for your MySQL install is now root/root! For security purposes, it's always best to change this. MY question - anybody? - is: How do I identify "other scripts which are running under MAMP" and also need to be changed? MAMP "help" (at bottom below) also says other scripts must be changed. I did so initially don't get the 1045 error often have NOT yet seen any consequences ] but am uneasy. So you might try using a text editor to change places in those files where a password for "root" appears. In /node/66187 it recommends what is reprinted below: I'm ALSO stuck getting 1045, but this may be a partial solution. I have done research online with little success. I also tried changing the 'auth_type', 'user', and 'password' parameters in the "" file as well and that left me with little success. Applications/MAMP/Library/bin/mysqlcheck: Got error: 1045: Access denied for user (using password: YES) when trying to connectĪnd this error with the MAMP start page opens:Įrror: Could not connect to MySQL server! However, after logging off and logging back on i get this message when trying to start the MySQL and Apache server: I completed all of this through the MAMP start page. The new account should have all the correct privilages. However, I tried creating a new USER and PASSWORD while still keeping the same root user and password. Mamp installed correctly with no problem. I downloaded the latest version of MAMP (using PHP 5 and the latest version of MySQL and Apache that comes with MAMP) I am trying to create a Dev environment in on my MacBook Pro using the latest version of Leopard. I am new to Drupal and I am experiencing the same problem. mysql_query($sho) or die(mysql_error()) Īfter all this, I have the following new error message: Access denied for user (using password: YES). $grt = "GRANT ALL ON *.* TO mysql_query($grt) or die(mysql_error()) Ħ. if(!mysql_connect (MYSQL_HOST, MYSQL_USER, MYSQL_PASS)) mysql_select_db(MYSQL_DB) Ĩ. I will show you the improved code and the new error message I got as below:Ħ. Swhisa_swhisa (Privileges: ALL PRIVILEGES)Īnd again I wrote the code inside the connecttodb.php just after connecting, as you recommended. And finally I tried everything with an query string, the last php code I showed you. I have given you the php connection code. That is the process.īelow is what I have been doing. Once we are connected to this panel, I have access to the MySql database through the username and password using and php code. Since we are client to the and we get the access through the username and pasword. ![]() Recently, we registered for cPanel and I am assigned to administer the web-based database management system.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |