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

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

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

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


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

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

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

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

PHPMyAdmin is a general MySQL client program. It prompts for a username and password which are used to access the database server directly. i.e. the database credentials and the credentials you enter into PHPMyAdmin are the same. To achieve what you want, create a new user for the database server and grant them privileges only on the database you want them ...


1

My Opinion I'm pretty sure you can add phpMyAdmin or search for another admin interface which has access to use specified commands in your databases by creating it in your website directory. Example I've made something similar when I had a game server where the admins could add/remove credits, items and others from users accounts, so you ...


1

What solved this issue for me was to search and purge every php-related package (now also including php-gettext and so on). After reinstalling the packets libapache2-mod-php5 php5 php5-mysql php-gettext php5-mcrypt php5-readline php5-gd php5-json and finally phpmyadmin, I could access phpmyadmin again, restore my website configurations and everything seems ...


1

There is an alternative way to export and import the database if you have terminal access to the server. Export the file via terminal Execute the following command replacing the MySQL username, database name, and the filename you wish to create. mysqldump -u <username> -p <dbname> > <filename>.sql Import the file using terminal After ...


1

Yes you can. You just export your database as sql file and import it via phpmyadmin. Export: Import: Note that if you have a very large sql file your host might not let you upload it via this wizard.


1

I suspected this was caused by running a (very) old version of PHP. (It seems PHP 4.2 was installed on the server). The reported "Parse error" is a fundamental syntax error at compile time. Any other problems such as libraries not being found or errors during object instantiation (at runtime) would have resulted in different errors/warnings. However, there ...


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

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


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