Hot answers tagged

5

You've just identified why phpMyAdmin should be only accessible through a protected backend like cPanel... or other means. If Google indexes it, you will be providing a Google Dork, the term for inept server admin mistakes. Lock down access to it via your .htaccess file with either a login or by limiting the ip addresses that can see the link with a 403 ...


4

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


4

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

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

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

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.


3

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 ...


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.


3

Most likely this is is caused by missing curl extension and disabled allow_url_fopen. Without these phpMyAdmin can not check for new version and doesn't report this anyhow. This will be fixed in future releases, see https://github.com/phpmyadmin/phpmyadmin/issues/11874


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)


2

So there are already some answers given. For the second set, the one with the http://url in the request, these tries to find badly configured (not secured) proxy servers that could be wide open. These can then be used to hide the real origin of attacks/scans directed onto an other machine. The other machine will then see the attack as if it was coming from ...


2

Keeping two databases in sync is known as "replication". MySQL supports database replication. In fact one of their use cases seems to match yours pretty well: Long-distance data distribution - if a branch office would like to work with a copy of your main data, you can use replication to create a local copy of the data for their use without requiring ...


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

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

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

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

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.


1

There's no relation between these two things from which to draw any comparison at all. Cloud hosting describes a general approach to things at the level of the server architecture, etc. cPanel is a specific application for managing a hosting setup. There's probably nothing stopping a cloud host from offering cPanel, for that matter. There are a lot of ...


1

Under "Host", try a %. like 192.168.0.% will do the whole network.


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

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

Navicat is a good MySQL editor and management application for windows.



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