Tag Info

Hot answers tagged

4

Looks like a corrupted installation of phpmyadmin. Make sure your permissions are set correctly. Also consider reinstalling phpmyadmin using the latest stable build.


3

Probably what happened is you opened a URL and the browser was redirected to the login page. But when you log in, the redirect is still cached (because PMA doesn't specify not to cache it). If you have submitted the login form, try reloading the page and it should let you in.


3

Changing the collation is what you want to do. Collations are rules regarding the sort order and search sensitivity. Every collation is based on a certain character set. There is no way to specify the character set separately from the collation.


3

You just add the same user multiple times under different hosts, like so: You can also just create one wildcard host user.


3

The WordPress codex has step-by-step instructions for Moving WordPress Within Your Site: Create the new location using one of these two options: If you will be moving your WordPress core files to a new directory, create the new directory. If you want to move WordPress to your root directory, make sure all index.php, .htaccess, and other ...


3

Update your phpMyAdmin. The latest version (3.5) has exactly what you describe.


3

If you are connecting to phpMyAdmin through HTTP then your password (and all your data) is being sent unencrypted. However, if the form you are using to enter your username/password is sent to an HTTPS script (even though you might be on an unencrypted HTTP page) then it is sent encrypted, but then you would expect to remain on HTTPS for the duration of ...


3

You have to configure PHPMyAdmin to connect to the MySQL database first. If you go to http://wiki.phpmyadmin.net/pma/Config you'll see that you need to add the following example to your config.inc.php file: $cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname $cfg['Servers'][$i]['port'] = ''; // MySQL port (leave blank for 3306) ...


3

I found the issue was the user for that cPanel account actually had an identical password to my WHM account and this threw an error (though user names were different). I changed it and it was ok.


2

Firstly, phpMyAdmin colours those tabs in red to attempt to avoid clicks, and when you click them you will either get a Javascript confirmation alert or go to another page that has the confirmation. So it's very difficult to accidentally drop an entire table. If that's still not satisfactory I would suggest editing the CSS. You'll need to edit the file ...


2

Since you want to avoid accidentally clicking drop and empty, create a user without drop and empty privileges for accessing the database from inside phpmyadmin. That seems a bit easier than trying to remove those tabs from code.


2

show procedure status will show you the stored procedures. show create procedure MY_PROC will show you the definition of a procedure. And help show will show you all the available options for the show command. This will work in phpmyadmin.


2

Given the configuration you describe I'm sort of surprised that you apache is starting. Try configuring your hosts file like this 127.0.0.1 localhost myawesomeproject.com then tidy up your vhosts like this <VirtualHost *:80> DocumentRoot "C:\xampp\htdocs" ServerName localhost </VirtualHost> <VirtualHost *:80> ServerAdmin ...


2

I realise this is an old post, but others with the same problem might find the solution useful. After spending ages with various fixes to session.inc.php I finally had a eureka moment and thought to check the PHP session save directory was correct and writeable. Setting NTFS permissions to Everyone on the folder has fixed it for me.. Doh.


2

How to set phpmyadmin prompt for login name and password Set the auth_type to http in you config file of phpmyadmin $cfg['Servers'][$i]['auth_type'] = 'http'; // Authentication method (config, http or cookie based) $cfg['Servers'][$i]['user'] = 'root'; // MySQL user $cfg['Servers'][$i]['password'] = ''; // MySQL ...


2

this one was tricky to figure out at first, but in the end it's the Egg of Columbus: Close all open instances to PHPMyAdmin in your browser Clear cache and passwords (depending on your browser) Visit your PHPMyAdmin URL (localhost/phpmyadmin for example) Enter your new username and password. Repeat process if you need to switch users again.


2

After googling this issue for ages I finally figured out what it was in my case. The problem was that google chrome does a validity check against the timestamp of the cookie (or something like this). Simply make sure that the server with PMA installed on it has the correct date/time settings and isn't out of sync. This should fix your problem.


2

Have a look here StackOverflow has numerous responses to this question.


2

Maybe some javascript libs (like CodeMirror.net) could add colors to phpMyAdmin editor but I think it's too much work with source code of phpMyAdmin. It's better and faster to use others application. For MySQL I use HeidiSQL (windows) or DBeaver (java = windows/linux/mac)


1

phpMyAdmin is a security hole waiting to happen. I use Navicat over an SSH tunnel. It's a native connection function they have and Navicat works a lot nicer as a complete phpMyAdmin replacement. You're not any longer dependent on a huge and slow php application to do your work. It was one of those programs worth the money I paid for it.


1

Everything in your code looks fine so your problem lies elsewhere. You need to use mysql_error() to tell you what you problem is. <?php //Connect to the server $connect = mysql_connect("localhost","root",""); //Connect to the database mysql_select_db("firstdatab"); $results = mysql_query("SELECT * FROM users WHERE FavNumber = '44' "); if ($results) ...


1

I can't find anything about this in the documentation, but I expect, from other databases I've used, that it is asking you which field to display from the second table when listing the first table. For example if table 1 is people and it has a field "country code". If table 2 is a list of codes and countries, and you set up a relationship between the two. ...


1

I hope this helps http://tech2view.com/not-able-to-access-phpmyadmin-in-ubuntu-404-not-found-error/


1

What errors did the error logs (access and or error logs)? That would help determining the issue. Could be a socket issue, but could be a url issue too. I assume PHP is installed too?


1

Every site is being attacked in the same way. There's no way to stop this from happening in the first place. It's just not practical. You can monitor your server logs and try to block IPs that are consistently offering your problems but the best you can really do is keep your software up to date. An interesting thing I found recently is 5G Blacklist. It ...


1

I kept running into this issue, then I realized that the hard drive on my server was full. This kept my PHP session information from storing (thus bouncing me back to the login page over and over). After clearing off some hard drive space, I was able to login again successfully.


1

What you should do is to modify $cfg['Servers'][$i]['hide_db'] because it accepts regular expressions so be default there is: $cfg['Servers'][$i]['hide_db']='(mysql|information_schema|performance_schema|test|phpmyadmin)'; You should change it into: $cfg['Servers'][$i]['hide_db']='^(mysql|information_schema|performance_schema|test|phpmyadmin)$'; Now ...


1

This may not help you but it might help someone else. Had installed EasyPHP wamp stack and could create a database in phpMyAdmin but it would not show up in the list of databases. I manually logged into mysql via the command line console and could see my database. Was banging my head against the wall on this one. Turns out I named my database test1 and ...



Only top voted, non community-wiki answers of a minimum length are eligible