![]() Questions in violation of this rule will be removed or locked. Specific assistance questions are allowed so long as they follow the required assistance post guidelines. General open ended career and getting started posts are only allowed in the pinned monthly getting started/careers thread. Problem you are attempting to solve with high specificity.Research you have completed prior to requesting assistance.If you are asking for assistance on a problem, you are required to provide If you post such content on any other day, it will be removed. Sharing your project, portfolio, or any other content that you want to either show off or request feedback on is limited to Showoff Saturday. We do not allow any commercial promotion or solicitation. Please refer to the Reddit 9:1 rule when considering posting self promoting materials. Because, when I upload it from windows, the connection is not establishing. ![]() 'Server: Localhost via UNIX socket' I want to change UNIX socket to 'TCP/IP'. When I open Godaddy phpmyadmin, database server looks like. Read and follow reddiquette no excessive self-promotion. 1 I am using windows and I want to upload mysql php project from localhost to Godaddy hosting. Check out /r/ProgrammerHumor/ for this type of content. Specific issues that follow rule 6 are allowed.ĭo not post memes, screenshots of bad design, or jokes. For vague product support questions, please use communities relevant to that product for best results. No vague product support questions (like "why is this plugin not working" or "how do I set up X"). Beginner question? Try the FAQ first! or the WebDev Resources Post then post in the Beginner Questions thread.At this prompt type the following: (Where ******** is the new password, NOTE: the single quotes ARE REQUIRED) mysql> UPDATE er SET Password=PASSWORD('********') WHERE User='root' įlush privileges will make the change take effect immediately. at the console, type: mysqld_safe -skip-grant-tables -autoclose.To change the mysql password for the root user, do the following: PS: contains more interesting settings :)įollow the root password change if you dont know the root password and then login in, it worked for me. So you get: $cfg = 'cookie' (or http if you wish)ģ) clear/delete all browser cookies for your server (usually look for localhost or 127.0.0.1 cookies)Ĥ) Go to phpyadmin's webpage again - now you will be prompted with login box (html or http - depends on whether you set the cookie or http)ĥ) LOGIN - AND YOU'RE DONE ! :) Suddenly 'Privileges'/'Users' tab is shown, the exit button appears suddenly too ! :) (next to the "little house"-left-top) $cfg = 'SOMETHING' - change 'SOMETHING' to 'cookie' you may find more of those configs, however the one you need is the one that contains line:.SET PASSWORD FOR = PASSWORD('YOURPASSWORDHERE') Ģ) Search for in your wamp/xampp folder and change auth_type: On a main page you should see the current root user - usually So query for password change:.Just for the record: mysql> USE mysql ġ) I set a root password through SQL query like this: My suggestion is that you either find CREATE scripts for the tables in database mysql or do a complete reinstall (as it appears, you don't have much DB's to lose anyway). So you've really deleted the 'user' table. You need to delete only the localhost cookies. Note that you can select what cookies to delete via the developers tab in Chrome. This, AFAIK, is a bug affecting Google Chrome in particular but I can't say for certain for other browsers. If you are sure that you are running as root, try clearing your cookies then refresh.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |