) ON er TO SELECT ON mysql.db TO SELECT ON mysql.host TO SELECT (Host, Db, User, Table_name, Table_priv, Column_priv) Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv,Įxecute_priv, Repl_slave_priv, Repl_client_priv Host, User, Select_priv, Insert_priv, Update_priv, Delete_priv,Ĭreate_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv,įile_priv, Grant_priv, References_priv, Index_priv, Alter_priv, GRANT USAGE ON mysql.* TO IDENTIFIED BY 'pmapass' mysql -u root -p < mysql_phpMyAdmin_pmaSetup.sql mysql -u root -p < /opt/local/www/phpmyadmin/examples/create_tables.sql Note: In MySQL versions beginning with 5.6.7, there is no mysql.host table, so you will need to edit the SQL code below: (i) in lines 9 and 17 delete "Host," from the the GRANT SELECT commands and (ii) delete the line 16 command "GRANT SELECT ON mysql.host TO HOW TO USE THIS FILE (with MacPorts installation) (It is not included with the phpMyAdmin distribution.) this is a one-time use scratch file so you can place it anywhere and delete it after use.Next: create a file: mysql_phpMyAdmin_pmaSetup.sql - containing the following SQL code: (change the 'pmapass' to your password) $ mysql -u root -p < /opt/local/www/phpmyadmin/sql/create_tables.sql Or alternately go to 'Operations' tab of any database to set it up there.įor additional features provided by pmadb ( ), first run The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. However, phpMyAdmin will flag the fact that it is missing and therefore certain features are not functional, with the message: Some consider the installation of pmadb "optional." Open localhost/phpmyadmin-doc in your browser et voilà! There it is. $ cp -R /opt/local/www/phpmyadmin/doc/html /Users/username/Sites/phpmyadmin-doc If you want to consult the phpMyAdmin manual, copy it into your DocumenRoot : Instead of the default value 'cookie', you might consider changing it to 'config' or 'http'.ĭetails on the three different options can be found in the chapter 'using-authentication-modes' in the phpmyadmin manual. It will be right at the beginning in the section labeled: "/* Authentication type */" $cfg = 'cookie' // Authentication method (config, http or cookie based)? - default is Cookie. However if you are a curious person, check the following: locate in this config file the line: There is no need to edit the file, so feel free to skip the following lines and goto Step 7: Create that file manually and copy in it the contents provided by WP.Ĭontinue the installation, and in less than a minute your Wordpress website is up and running. When installing WP, you will see that macOS prevents WP from creating the file wp-config.php in your DocumentRoot. Next download for example WordPress and copy it's files into your DocumentRoot. Installing a CMS like Drupal, Joomla or WordPress should be a piece of cake.įirst step is to create in mysql a new user and the new user's database. Now accessing databases in MySQL with phpMyAdmin should work. Mysql> ALTER USER IDENTIFIED WITH mysql_native_password BY 'here your password for root' So let's change the encryption for the user root in mySQL to a weaker level: The reason for it is, that mySQL uses strong encryption, There is a fair chance you can't login and will see two pink colored boxes with cryptic error codes in it. Try to login as root with the MySQL password for root. To check your phpMyAdmin installation, point your browser to and verify that phpMyAdmin loads and you get it's login page. $ sudo cp -R /opt/local/www/phpmyadmin/ /Users/username/Sites/phpmyadmin $ sudo cp Īssuming that you have /Users/username/Sites as DocumentRoot for Apache, copy and paste phpMyAdmin in it : Next let's configure and test if phpMyAdmin can access MySQL. Step 4 was the installation of phpMyAdmin. phpsĪs a last check, reboot and verify that everything has autostarted and is running (i.e., repeat the above tests). Step 5: Visit howto/MAMP for integration informationĪnd then add the following two lines before the end of that block.ĪddType application/x-httpd-php-source.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |