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


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

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) $cfg['Servers'][$...


3

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: mysql --help The location displays similar to the following: Default options are read from the following files in the given order: /etc/my.cnf /etc/mysql/my....


2

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


2

According to this: http://docs.cloudlinux.com/entry_processes_limit.html Entry process limits are designed to prevent hackers from slowing down the server. What you should do is take a closer look at your processing time. Run a test on webpagetest.org and check the values for "time to first byte". If it's over 1/5th of a second then its a processing ...


2

TYPE should be ENGINE CREATE TABLE `sbbleads_admin` ( `sb_id` BIGINT( 20 ) NOT NULL AUTO_INCREMENT , `sb_admin_name` VARCHAR( 255 ) DEFAULT NULL , `sb_pwd` VARCHAR( 255 ) DEFAULT NULL , PRIMARY KEY ( `sb_id` ) ) ENGINE = MYISAM ;


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

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


2

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


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

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

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


2

Add the following lines to php.ini file, max_input_vars = 5000 suhosin.request.max_vars = 5000 suhosin.post.max_vars = 5000


2

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


2

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


2

Previously answered correctly here: https://serverfault.com/a/435443 The answer: Execute your sql query in the SQL tab of phpMyAdmin. After execution, scroll down the page and look for “Query results operations” Click “Export” link from the above and you will get the page to export all the results of the queries to desired format. That’s it. Note: The ...


1

In you case it is already securised as setup.php is not allowed. More advices: keep your phpmyadmin uptodate change default folder name Here you can find an extra rule for Apache to redirect to nowhere 90% of bots: RewriteCond %{HTTP_USER_AGENT} ^-?$|curl|perl|python [NC,OR] RewriteCond %{REQUEST_METHOD} !^(GET|HEAD|POST)$ [OR] RewriteCond %{REQUEST_URI} ...


1

Depending on your setup, you need to locate the correct .conf file (like apache-xampp.conf or httpd.conf or apache.conf or phpmyadmin.conf) in your web server installation directory for below lines and then Ctrl+F for phpmyadmin to find something like below: <Directory /usr/share/phpmyadmin> ## The path here will vary depending on your setup and you ...


1

First change the URL for access. Then when the URL is reached, one should be asked for a valid username or password before accessing the actual phpmyadmin interface. Also, To increase the odds of a phpmyadmin URL not being indexed by any search engine make sure it is told not to index. Modify the Phpmyadmin code and make sure that: header("X-Robots-Tag: ...


1

It seams like the best way to go about it, is to have a php file which returns the output of your data set; and just make a ajax call to it. Maybe these resources will help: https://stackoverflow.com/questions/3288709/load-javascript-array-with-mysql-database-data https://stackoverflow.com/questions/9964799/load-data-from-database-using-javascript https://...


1

You could disable ForceSSL within PHPMyAdmin but there's a reason why its forced and this is to make the connection more secure. I recommend that you move to doing redirects using .htaccess rather than using virtualhost method, by doing so you have more control on your redirects for each of your web applications. In /var/www/.htaccess it should look ...


1

i just found why i was not getting it. click on wamp icon and go to phpmyadmin and click on database where u can see a database called mysql. So add database name as : mysql and username :root , password: leave as blank , admin and password : anything u wish. Maybe this is very simple .Posting it for starters who are stuck here.


1

If your database is truely 'corrupted' as you stated, you are unlikely to be able to retrieve your post/page content. In either case, it is located inside your MySQL database inside the wp_posts table and more specifically the post_content column.


1

There are hundreds of variations to development workflow and what you use should be tailored to what you need and how you work. XAMPP offers the ability to develop locally. It doesn't provide an ability to push those changes to a live server or sync between the two. Many text editors will provide you with the ability to push changes live (such as Sublime ...


1

Problem Solved! When installed zPanel create a file named as passwords.txt. To view the file you just need log in ssh and write: vi passwords.txt to exit just write: :quit and press enter.


1

Okay. Most of these access (at least) are landscaping attempts to find potential vulnerabilities on your server. They are trying to fingerprint your server to know what web-based applications are installed. The first set and third set are clearly landscaping. The second set may be a result of forged request headers but still likely to be landscaping- not ...


1

When exporting, phpmyadmin has an option (under the "custom" configuration) to "CREATE DATABASE / USE statement". If you didn't check that, then your export file won't create the databases. As far as recovering, you'll need to create each database manually. Not the tables and schemas though, just create the database itself and your existing default export ...


1

"From what I understand....." Not really. Certainly more requests means more process and longer requests means more concurrent processes. But that should not be your your starting point for managing capacity on a server unless your business model is to make money by selling processing capacity. Determing exactly how many concurrent requests your stack can ...


1

Broadband Outrages 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. Dynamic IP If your IP changes then your going to need a Dyn ...


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