![]() After several tries, I ended up solving the problem. 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. Restart the MySQL server: $ sudo /opt/bitnami/ctlscript.I use MAMP to run all the things needed to develop web sites with symfony (php based framework). If your stack ships an older version of MySQL, use this command: $ sudo /opt/bitnami/mysql/bin/mysqld_safe -pid-file=/opt/bitnami/mysql/data/mysqld.pid -datadir=/opt/bitnami/mysql/data -init-file=/tmp/mysql-init 2> /dev/null & If your stack ships MySQL v8.x, use this command: $ sudo /opt/bitnami/mysql/bin/mysqld_safe -pid-file=/opt/bitnami/mysql/data/mysqld.pid -datadir=/opt/bitnami/mysql/data -init-file=/tmp/mysql-init -lower_case_table_names=1 2> /dev/null & Stop the MySQL server: $ sudo /opt/bitnami/ctlscript.sh stop mysql TIP: Check the MySQL version with the command /opt/bitnami/mysql/bin/mysqladmin -version or /opt/bitnami/mysql/bin/mysqld -version If your stack ships MySQL v5.6.x or earlier, use this content: UPDATE er SET Password=PASSWORD('NEW_PASSWORD') WHERE User='root' If your stack ships MySQL v5.7.x, use this content: ALTER USER IDENTIFIED BY 'NEW_PASSWORD' If your stack ships MySQL v8.x, use this content: ALTER USER IDENTIFIED BY 'NEW_PASSWORD' ĪLTER USER IDENTIFIED BY 'NEW_PASSWORD' If you don’t remember your MySQL root password, you can follow the steps below to reset it to a new value:Ĭreate a file in /tmp/mysql-init with the content shown below (replace NEW_PASSWORD with the password you wish to use). $ /opt/bitnami/mysql/bin/mysqladmin -p -u root password NEW_PASSWORD Replace the NEW_PASSWORD placeholder with the actual password you wish to set. You can modify the MySQL password using the following command at the shell prompt. NOTE: When setting a new password, avoid the use of special characters or quotes, as this can sometimes cause issues when accessing the database through shell scripts. The output of the command indicates which database server (MySQL or MariaDB) is used by the installation, and will allow you to identify which guides to follow in our documentation for common database-related operations. To identify which database server is used in your stack, run the command below: $ test -d /opt/bitnami/mariadb & echo "MariaDB" || echo "MySQL" On account of these changes, the file paths and commands stated in this guide may change depending on whether your Bitnami stack uses MySQL or MariaDB. NOTE: We are in the process of modifying the configuration for many Bitnami stacks.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |