- Change root user password mamp phpmyadmin how to#
- Change root user password mamp phpmyadmin update#
- Change root user password mamp phpmyadmin driver#
- Change root user password mamp phpmyadmin mac#
Limit user’s access only to some records of your Model.Pre-fill a form in the backend with symfony.Symfony, MAMP, PhpMyAdmin, password changed….
I stil have trouble installing Xdebug but I will tell you as soon as it will be solved ! Hope it helped… Sudo ln -s /Applications/MAMP/Library/bin/mysql /usr/bin/mysql Sudo mv /usr/bin/mysql /usr/bin/mysql-old Sudo ln -s /Applications/MAMP/bin/php5/bin/pear /usr/bin/pear Sudo ln -s /Applications/MAMP/bin/php5/bin/php /usr/bin/php
Change root user password mamp phpmyadmin mac#
For a reason I still ignore, the symbolic links that you create when installing MAMP for symfony (to replace by default MAC apache and sql servers) were no more existing !! So just recreate them by typing the following lines in the terminal and every thing should work well : sudo mv /usr/bin/php /usr/bin/php-old After several tries, I ended up solving the problem.
Change root user password mamp phpmyadmin driver#
When doing a « build-all-reload » on symfony, I suddenly had the following error message : « Couldn’t locate driver named mysql ». Now you will be asked to enter by hand your db name and password, and this it, you can acces to PhpMyAdmin !!!!īy the way, I faced another problem and couldn’t find the solution on the net so it might be useful for some one facing the same issue. $cfg = 'cookie' // Authentication method (config, http or cookie based)? Then, you will still be unable to connect to phpMyAdmin, so you have another thing to do, its to change the authentification setting from ‘config’ to cookie.įor this, go to /MAMP/bin/PhpMyAdmin/ on line 84 and change the line to this : //./MAMP/bin/PhpMyAdmin/ Go to /MAMP/bin/MAMP/index.php and change line 15 to this : //./MAMP/bin/MAMP/index.php You just have two things to change.įirst, give MAMP the new password you set up for your database. This is easy to do, you just have to go to « preferences » (when you click on the MAMP icon) then « apache » and upload the root directory.īut then I changed the sql password… and I was unabled to access to PhpMyAdmin any more !! I had a message error of the following type : « sql error, cannot find sql server on localhost » or something like that… So after hours of searches on the net and in my brain, I finally solved this problem. I relocated my web projects in a different directory from the one used by mamp (the htdocs directory). I won’t come back with installation process and symfony compatibility, there are several good posts, the best one being this one (according to me !)īut even if this post, I was unable to set up properly virtual hosts, which is unconvenient but doesn’t prevent you from using MAMP. Even if I am not 100% satisfied, I did not find any other solution and I must admit it is pretty simple to install. Having reset the root user password you should follow the instructions here regarding updating the necessary files in MAMP with the new password.I use MAMP to run all the things needed to develop web sites with symfony (php based framework). Applications/MAMP/Library/bin/mysqladmin -socket=/Applications/MAMP/tmp/mysql/mysql.sock shutdown -u root -p
You’ll be prompted for the new root password when you press enter. Type the following command to shutdown MAMP’s MySQL server. You should be returned to the Terminal prompt. Then, to quit the MySQL command line type: \q Press enter, then type: FLUSH PRIVILEGES
Change root user password mamp phpmyadmin update#
Type the following, replacing NewPassword with the password of your choice: UPDATE er SET Password=PASSWORD('NewPassword') WHERE User='root' You should see the MySQL command line prompt: mysql>
mysqld_safe Starting mysqld daemon with databases from /Applications/MAMP/db/mysqlĪt the prompt type the following command to access the MySQL command line: /Applications/MAMP/Library/bin/mysql When Terminal displays the following message, press enter again to return to the Terminal prompt. Stop the Apache and Mysql using the MAMP UIĬopy and paste the following command into a Terminal window and press enter: /Applications/MAMP/Library/bin/mysqld_safe -skip-grant-tables -skip-networking -socket=/Applications/MAMP/tmp/mysql/mysql.sock -lower_case_table_names=0 -pid-file=/Applications/MAMP/tmp/mysql/mysql.pid &
Change root user password mamp phpmyadmin how to#
So here is an easy way how to reset your root password. You maybe forgot the root password of your mysql installation, or something went wrong during the installation, or …. Mysql: Reset root password without knowing it (Mac MAMP)
0 kommentar(er)
