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 ...
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 ...
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)
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 ...
It sounds like you have the default settings, which, in most Windows packages I've seen, usually means that logging as 'root' with password '' is hard-wired into the code and ignores cookies etc. This means it will never offer a log-in window, because it thinks it already has your details, and until you change these settings, uberconversion's answer won't ...
Create the remote connection
To create a remote connection:
On your database server, as a user with root privileges, open your MySQL configuration file.
To locate it, enter the following command:
The location displays similar to the following:
Default options are read from the following files in the given order:
What you should do is to modify $cfg['Servers'][$i]['hide_db'] because it accepts regular expressions so be default there is:
You should change it into:
Now only ...
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 ...
It's better and faster to use others application.
For MySQL I use HeidiSQL (windows) or DBeaver (java = windows/linux/mac)
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.
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.
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 ...
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 ...
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
Export from command line if you have having issues with exporting from phpMyAdmin.
backup/export: # mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql
restore: # mysql -u root -p[root_password] [database_name] < dumpfilename.sql
Similar question on StackOverflow
According to FastHosts, you can access cPanel in three steps:
Step 1: Open an Internet browser and enter https://yourserverip:2083 replacing yourserverip with your server's IP address.
Step 2: If this is the first time you have accessed cPanel, your browser will show a security warning. This is due to cPanel and WHM being secured using a self-signed ...
Generally, In Shared Hosting you are not allowed to change php.ini file.
But many hosting providers allows to change such parameters of php.ini file through Control Panels like cPanel / Plesk / etc.
Also some of them allow limited SSH access to the files and server, you can try whether it helps or not.
Best way is ask your hosting provider about the ...
It's doable but one of the problems is that home connections are not as reliable or stable as you may think. DNS issues occur very regularly on home broadband as well as other problems, also your IP may change (Dynamic) and this causes all types of problems with domains.
If your IP changes then your going to need a Dyn ...
Dropbox can not be used for sharing a database. Its not a normal file that can be copied.
There are a few options on working around this.
Use Mysqldump and export your databases then copy to dropbox. This would be every time you switch computers.
Set up a SSH tunnel to connect to MySQL on the other computer.
ssh -fNg -L 3307:127....
Try to access phpMyAdmin not from the WHM panel, but from the cPanel using the login details of a specific user, not the login details of a root user.
In case you are not able to access phpMyAdmin from cPanel, this means that you need to get in touch with support and ask them for assistance.
Your phpmyadmin configuration file contents in wamp alias folder must look as below:
Options Indexes FollowSymLinks MultiViews
Allow from all
Whereas it looks as this:
It could be a number of things but it is probably that apache is Listening on the W8 IPV6 default localhost address which is ::1
edit httpd.conf, using the link on the wampserver icon wampserver -> apache -> https.conf
find the line > Listen 80
and change to > listen 0.0.0.0:80
This will force apache to listen on IPV4 and make the pre-configured phpMyAdmin ...
Usually custom hosting applications used for shared hosting do not have phpMyAdmin functionality in terms of a front end GUI.
Instead, the hosting company will craft their own GUI hosting controller app and simply have it interface with a command line php/MySQL on their server, thereby disabling access to you directly.
You can try using phpMyAdmin's ...
First question: Are you actually accessing it from localhost? (127.0.0.1 ONLY!)
In your httpd.conf file or somewhere in the main Apache config, you've probably got a line like "AllowOverride None" and should be set to All instead. (That prevents .htaccess files from working properly (security).
Or even it might in the PHPMyAdmin configuration. I couldn't ...