Tag Info

Hot answers tagged

41

Don't worry about it. Serving a 404 is a tiny, tiny, tiny amount of work for a web server to do. You could probably serve ten 404's a second using a 486. The bandwidth per 404 is negligible; a tiny GET request and a tiny 404 response. Seriously; don't worry about it. This is just part and parcel of running a server on the internet.


34

Unfortunately for You this is how Internet works. Just ignore it. Thousands of bots/trojans scan the Internet. Source IP will be always random. There is no cure. The only 100% solution for eliminating that traffic is illustrated below: An alternative is: - to move with https/http from port 80/443 to something else. Bots usually don't look for http server ...


26

You simply need to log out of phpMyAdmin or remove the session cookies and reload once the changes are made.


25

What you want is Fail2ban (assuming this is a linux machine, you didn't say...) What is Fail2ban? Fail2ban will parse system logs, looking for particular regular expressions to block. When it finds a match (or several matches from the same IP, depending on how you configure it), it will block, typically through IPTables. Typically this is used to block ...


14

MySQL will try to connect to the unix socket if you tell it to connect to "localhost". If you tell it to connect to 127.0.0.1 you are forcing it to connect to the network socket. So probably you have MySQL configured to only listen to the network socket and not to the file system socket. What exactly is wrong with your unix socket is hard to tell. But I ...


13

We do a combination of things: Protect phpMyAdmin via .htaccess or Apache configuration which requests a HTTP username/password login. Protect phpMyAdmin via .htaccess or Apache configuration to only allow access from certain trusted IP addresses Put phpMyAdmin in it's own VirtualHost and run it on a non-standard port Only allow HTTPS connections to ...


13

You can turn on the option AllowNoPassword on file /etc/phpmyadmin/config.inc.php. Edit the file config.inc.php, search and uncomment this line: // $cfg['Servers'][$i]['AllowNoPassword'] = TRUE; Then you can access PhpMyAdmin without password.


12

It looks like your permissions on /tmp are wrong. They really should be read/write/execute for everyone with the sticky bit set. chmod 1777 /tmp The sticky bit add some restrictions to how other users interact with files not created or owned by them, so there's no reason to worry. If you wish, you may also create a seperate directory owned and writeable ...


10

In /etc/apache2/mods-available/suphp.conf following two lines: AddType application/x-httpd-php .php .php3 .php4 .php5 .phtml suPHP_AddHandler application/x-httpd-php should be changed to: AddType application/x-httpd-suphp .php .php3 .php4 .php5 .phtml suPHP_AddHandler application/x-httpd-suphp Then, in /etc/suphp/suphp.conf line ...


10

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.


9

Replace "timestamp(14)" by "timestamp" in /usr/share/dbconfig-common/data/phpmyadmin/install/mysql (pma_history section). Then reinstall phpmyadmin.


8

SELECT * FROM mysql.db WHERE Db = '<database name in LC>';


7

Sure. You can restore it from your backup. Otherwise, you're out of luck, unless your ISP has a backup that can restore it. You'll need to talk to them about that, though... They may charge you for doing so.


7

After some digging, the answer in the MySQL/phpMyAdmin context is as follows: Synchronization: Brings 2 DBs in sync (schema and data)Note: This is a 1-time process, which can be run every time you would like to sync 2 DBs, but is triggered manually. Replication: This is used to continuously (automatically) replicate data between 2 DBs. This is done ...


7

Use dpkg -L phpmyadmin to list the files installed by the package.


7

The best way to load test your software and environment is to put it, or an identical system, under artificial load. If the game can be scripted do so and have many scripted players login and play from a neighbouring machine, slowly ramping up the number of artificial players until response times start to head towards levels that are not acceptable. This ...


7

Use mysqldump to dump the contents of the database to disk instead.


7

Nick - have you used Linux before? If so, then you should be familiar with logging-in via ssh to the ip address given to you, along with the username and password. If not, I'd highly recommend finding someone you know who's experienced with the platform and learning from them! A quick SSH howto: http://kimmo.suominen.com/docs/ssh/ To install ftp - yum ...


7

Since that appears to be an Apache config I suspect you also need to add a Listen directive to the /etc/apache2/ports.conf (for Debian). It should be Listen 555.


7

Remove the Alias declaration Alias /phpmyadmin /usr/share/phpmyadmin from the server context and put it in the relevant vhost context <VirtualHost *:80> ServerName onlyphpmyadmin.domain.com . . . Alias /phpmyadmin /usr/share/phpmyadmin </VirtualHost> It may be easier and preferable to just include the whole phpmyadmin ...


6

You may have IPv6 enabled, its very possible localhost resolves to the ipv6 localhost, that is not defined in your msql config. ive also had a problem where i had to add 'localhost' in place of '127.0.0.1' to the allowed subnets for that user, dont understand why (i was using ipv4 and it was a while ago) but its worth a try.


6

Are you setting up your phpmyadmin config correctly with the server's information you want to conect to? see the phpmyadmin wiki page: http://wiki.phpmyadmin.net/pma/Config#Server.28s.29_configuration It should be as simple as just typing in the SQL server's IP/domain. Additionally you can specify a username and password in the config. But if the ...


6

Block this using just IPtables will be a futile endeavor, as PHPMyAdmin is a very attractive target for attackers and you will get other attempts from other addresses. You have the following options, sorted in order of reliability: Get rid of the unsecure pile of garbage that is PHPMyAdmin and remove it from your system. If that's not possible, limit ...


6

I installed IUS and RPM Forge Release and then removed old packages. with a dump from MySQL for sure. and then re-installed PHP54 and MySQL55. assuming it's CentOS/RHL 5 and you have old PHP & MySQL installed first find all packges related to php by: rpm -qa | grep php then remove matched packages: yum remove [packages] then search for mysql: ...


6

mysql is not running - why don't you try starting it And of course none of this should be a real issue because you have regular backups right?


6

Make phpmyadmin available on a vhost that is only accessible from localhost and require users to use ssh and port forwarding to get access to it.


6

Would you recomend installing/using phpMyAdmin on a prduction webserver? No, simply. phpMyAdmin has an infamous security history as detailed on SecurityFocus. You don't say what platform you're using, but assuming that you have remote access, I suggest: When you need to perform basic tasks such as checking status or performing a dump. Learn how to ...


6

Add a .htaccess which only allows local IP access to the phpmyadmin folder.


5

Open up a terminal. $ mysql -u root --host=127.0.0.1 -p<yourpassword> Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 521 Server version: 5.1.38yes-debug yes Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> CREATE USER 'root'@'localhost' IDENTIFIED BY ...


5

personally i like the official mysql tools best! Mysql Workbench quoting from their website: MySQL Workbench provides DBAs and developers an integrated tools environment for: Database Design & Modeling SQL Development (replacing MySQL Query Browser) Database Administration (replacing MySQL Administrator)



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