- #MAMP PHPMYADMIN RELATION VIEW HOW TO#
- #MAMP PHPMYADMIN RELATION VIEW CODE#
- #MAMP PHPMYADMIN RELATION VIEW PASSWORD#
#MAMP PHPMYADMIN RELATION VIEW CODE#
I left mine phpMyAdminģ.Open phpMyAdmin and go to the Import tab.Ĥ.Click the browse button and find the create_tables.sql file and then click Go.ĥ.The tables required for Relation view will be added to the database you specified.Ħ.Open /Applications/MAMP/bin/phpMyAdmin/ħ.Find the Server(s) configuration code block and replace/uncomment the following code and fill in the values. If you can’t you’ll need to follow the steps below to set phpMyAdmin to enable Relations view.ġ.Find /Applications/MAMP/bin/phpMyAdmin/scripts/create_tables.sqlĢ.I left this file default but you can change the table name to anything you want. Depending on your version of phpMyAdmin you should see a link titled Relation view below the table structure. Now, go back to your table view and click the Structure tab. Make sure that the storage engine is set to use InnoDB and save your changes. Click on a table within your database and choose the Operations tab. You need to make sure your tables’ storage engine is set to use InnoDB.
To do this open phpMyAdmin and select a database.
#MAMP PHPMYADMIN RELATION VIEW HOW TO#
If you’re creating a database you might be wondering how to create relationships and foriegn keys for your tables.įirstly you need to check that you have access to the Relation view. If you’re using MAMP for your database driven projects you’ll probably be using phpMyAdmin to administer your MySQL database if you’ve decided to go down that route. Once you find the second MySQL installation, I suggest removing it entirely (while maintaining the data directory that you need), because no good can come from having two different MySQL installations fighting for the same resources.Īn alternative explanation would be that you're not connecting as an actual user, but as the anonymous user, which could hide all the normal databases from your view.Now !! after searching for a long time ,I have to find the way to reslove this prolem. You might try which mysql at the command line, or which mysqld which might give some clue where it's running from. You should examine your system for another MySQL installation. This is further reinforced by the paths /usr/local/mysql-5.7.17-macos10.12-x86_64 doesn't seem like a MAMP path (though I don't use MAMP, so I don't know for sure). That would explain why the MAMP status is showing that MySQL isn't running, but you're still able to connect and would also explain why you're not seeing existing database when you connect. It sounds like you might have two different MySQL servers running on your system. I have reinstalled MAMP which has made no difference. So the question is now how to get MAMP/phpMyAdmin to point to the db files in MAMP/db/mysql56 and not usr/local/mysql/data (usr/local/mysql is actually sym linked to usr/local/mysql-5.7.17-macos10.12-x86_64)
Step-9 So I created a new DB and tried to find that in the Finder, which I did in usr/local/mysql/data – although I was locked out of 'data' until I changed it's permissions to 755. Still no databases listed and MAMP mySQL Server indicator still off. When I go into phpMyAdmin non of my databases are listed. So I am now into phpMyAdmin, although the MAMP mySQL Server indicator is still not on. Step-7 Bit more google-foo – changed localhost to 127.0.0.1 in MAMP/bin/phpMyAdmin/ Step-6 Checked the symbolic links from step 1 and now tmp/mysql now points to MAMP/tmp/mysql/
#MAMP PHPMYADMIN RELATION VIEW PASSWORD#
Step-3 Bit more google-foo – I used terminal and changed the password to 'root' which is what the MAMP start page said the mysql password should be. Mysqli_real_connect(): (HY000/1045): Access denied for (using password: YES) Step-2 Bit more google-foo – in MAMP I changed the mysql to 3306 – and then error changed to: Mysqli_real_connect(): (HY000/2002): Connection refused Step-1 After some google-foo – I symbolic linked /tmp/mysql.sock to /var/mysql/mysql.sock – then error changed to: Mysqli_real_connect(): (HY000/2002): No such file or directory. For some reason MAMP, mySQL server and phpMyAdmin started acting odd.įirst off in MAMP the mySQL Server indicator was not on (although it's on in system prefs) and when launching phpMyAdmin I was getting the error:
0 kommentar(er)
