Thanks a lot guys, you guys are awesome and have helped me a lot. I might be organizing these tables all wrong. In your My Products page, next to Web Hosting, select Manage All. This is a PHP/MySQL quiz application that keeps track of member results. Sign in to phpMyAdmin Go to your GoDaddy product page. Depending on the number and types of accounts you have. I am including my SQL tables structure in case you want to look at it and tell me what is wrong with the way I have structured my tables or why the foreign key relationship is wrong and how it needs to be fixed. To do this, simply click on the Users tab and then click Add User. here's the steps I followed, perhaps I'm missing something I created the pma user and granted proper permission to the phpmyadmin table: GRANT USAGE ON mysql. My questions are: 1) Why the different colors? 2) What does each color mean? 3) If red means that the relationship is wrong, why is it wrong and how do I fix it? 1 I've been trying for hours to enable phpMyAdmin Designer Mode on a CentOS cPanel dedicated server with no luck. To enable the designer tab : Edit In case only available then you need to rename the file into Locate these lines : phpMyAdmin configuration storage settings. I guess yellow means caution (or warning) and I suppose that red means that this relationship is a bad one and should be deleted. It is obvious that green means that the relationship is a valid one and I think the same thing is true of blue. The colors are blue, green, yellow, purple and red. There are a lot of different colors connecting the foreign keys from one table to the other table. We are going for it at the root of the web. 2) After saving all these changes, we will then import a file in SQL format that will allow phpMyAdmin to have its own table containing the configuration. Ok, so I clicked on the Designer tab in phpmyadmin to see the relationships between my tables. So let’s begin, to activate designer mode we’ll start by going to find a file name as in the phpMyAdmin installation directory.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |