Tag Info

Hot answers tagged

2

If the user has: Physical hardware access; Root / "Administrator" access to the system; or PostgreSQL superuser rights; then they effectively have total control and can do whatever they feel like. It's a little trickier when starting with superuser access, but the PostgreSQL superuser is not isolated from the underlying OS user that PostgreSQL its self ...


1

SHOW GLOBAL STATUS LIKE 'Uptime'; http://dev.mysql.com/doc/refman/5.6/en/server-status-variables.html#statvar_Uptime


1

You do not need to purge anything, you just need to follow these instructions to reset the administrator password. If you happened to delete the admin user, just create a new one on the init file: create user root@localhost; grant all privileges on *.* to root@localhost;


1

You told it to generate html. $ mysql -H my_base The -H option is an alias for the --html option. I assume you were thinking of -h ... which is the shortcut for --host. http://dev.mysql.com/doc/refman/5.5/en/mysql-command-options.html#option_mysql_html


1

The PostgreSQL protocol cannot support hostname based virtual servers, because the client doesn't send the hostname of the server in the initial connection packet like HTTP does in the Host header. Your only option is to add additional Elastic IP addresses. You will need to be able to tell which traffic came from which IP. Because EC2 instances don't have ...


1

Start with (use the appropriate install syntax for your distro) sudo apt-get install libaio1 and if that doesn't do the trick, do sudo apt-get install libaio libaio-dev Paul...


1

Search for mysql-related packages that are now installed: rpm -qa | grep -i mysql Delete any packages like mysql, mysql-server, mysql-client, mysql-shared, mysql-shared-compat, mysql-libs. yum remove mysql-server You do not need to remove mysql library bindings like python-mysqldb, php-mysql, etc., unless they had a dependency with some of the previous ...


1

With your initial feedback (you are using innodb), I can tell you that your innodb_buffer_pool_size is too small (2M), so most of your queries may be using disk instead of memory. As a rule of the thumb, for a dedicated server, the usual recommendation is reserving between 60-85% of the available memory for the innodb buffer. Increase it by setting it in ...



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