Hosting Blog

Tag overview for: 'mysql'

Entries on this site with 'mysql'

• Steps to install the Gallery application manually with Linux hosting
  Please follow the steps below to install the Gallery application:- 1. Download the package from the official website or through any other means of Internet resources. 2. U
• SQL query to set/update the MySQL user password in the old style
  The following query can be used to set/update the MySQL user password in the old style:- SET PASSWORD FOR 'user'@'%'=OLD_PASSWORD('password'); FLUSH Privileges;
• MySQL Error: Prepared statement needs to be re-prepared
  To fix this error, first try to restart the MySQL services. Otherwise, try modifying any of the following database settings: tmp_table_size 32M=>64M join_buffer_size 256k=
• MySQL Error 1129: Host 'xxx.xx.xxx.xxx' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
  To fix this error, run the command below:- ]# mysqladmin -p flush-hosts    where -p = password of the MySQL admin (root) user.
• Taking a backup of a MySQL table and restoring it
  Use the command below to take a backup of only one table: # mysqldump -u db_username -p mydatabase table1 > table1.sql Use the command below to restore the table: #mysql -
• Steps to Reset the Database User Password from the Plesk Control Panel
  Please follow the steps below:- 1. Login to the Plesk control panel. 2. Go to Domains. 3. Select the Domain. 4. Go to Websites and Settings. 5. Find the database there. 6.
• DNS lookup optimization for the MySQL server: skip-name-resolve
  To increase the MySQL server performance if there are many hosts and if DNS is slow, consider disabling DNS lookups with --skip-name-resolve or consider increasing the val
• Joomla jos_session table crash?
  Sometimes because the session wasn't properly closed and because it was stopped in some improper manner, we've seen that the Joomla jos_session table crashes due to which
• Error: Your PHP installation appears to be missing the MySQL extension which is required by WordPress.
  Error:- Your PHP installation appears to be missing the MySQL extension which is required by WordPress. You need to place php.ini inside the domain folder and uncomment th
• How to suspend or resume a MySQL abusive user in the H-Sphere cluster?
  1. Run the following command to suspend a user:- ? ? /hsphere/shared/scripts/mysql-suspend-user username 2. Run the following command to unsuspend a user:- /hsphere/shared
• How to restart MySQL from the server if it is taking many connections
  Steps to restart the MySQL service if it is taking many connections :- step1? pgrep mysql (it will show the processes' ids) step2? pgrep mysql > mysql.txt step3? for i in
• MySQL is running but the PID file cannot be found?
  Sometimes when we try to stop the mysqld service on the server we get the error below :- MySQL is running but PID file could not be found [Failed] There are several reason
• How to remove a MySQL database without removing its db user which is being used with another database as well?
  In H-Sphere, if we have several databases and have a common db user for all and at some point remove a database then this will remove the database user for all the databas
• Changing the MySQL password
  Please follow the command below to set your password for the first time for MySQL:- # mysqladmin -u root password YOURPASSWORD We can change the root password through the
• How to see the records/contents of a MySQL database table?
  If you have your own server and have MySQL installed with some database, and would like to view the contents of a table in that database, then you can follow the steps bel
• How to take a MySQL database schema backup using the command line
  The following command can be used to take a MySQL database schema backup on the command line :- command : mysqldump -u dbusername -p passwd datbase_name --no-data=true >>
• Steps to increase the MySQL / MSSQL / PgSQL database quota in H-Sphere
  Please follow the steps below: 1) Login the H-Sphere control panel. 2) Select Database >> MySQL / MSSQL / PgSQL DBs. 3) On the page that appears, you can see the existing
• Steps for Joomla installation
  Preparations before installing Joomla:- 1- Make sure the Joomla files have been uploaded to the domain directory. 2- Make sure that the database has been created in H-Sphe
• A MySQL user disappeared during a permission change. How to add the user back?
  Please follow the steps- 1. Login to the control panel. 2. Go to the Databases menu > MySQL > MySQL DBs. 3. Click on the database for which the user has disappeared. 4. Cl
• MySQL DBA permissions
  Issue : While restoring the MySQL database using a third party tool like SQLyog, sometimes we get an error like this : Error occured at:2013-07-01 15:00:44 Line no.:XX Err
• Backup or Restore your Mysql Database using phpMyAdmin
  Taking a Backup or Export of your MySQL database using phpMyAdmin :- -------------------------------------------------------------------------------------------------- Ste
• How to check and change the collation and charset on a MySQL Database
  There are times when a user needs a different collation and character set for the MySQL database instead of the default one and to do so as below is the way. First login o
• Alternative IPs with ports to access the MSSQL and MySQL servers through external tools
  Below are the IP addresses and ports for the respective server for external management access :- ======================================================================== C

Related tags

1129, abusive, access, alternative, application, backup, change, charset, cluster, code:1142, collation, command, commandline, connection, connections, contents, control, controlpanel, conversion, crash, database, dba, dbs, dns, error, export, extension, external, flush_hosts, gallery, hosting, hostname, hsphere, import, install, installation, ip, ipaddress, jodohost, joomla, jos_session, linux, linuxhosting, lookup, manually, many, missing, mssql, mysqladmin, mysqld, old, optimization, panel, password, permission, pgsql, php, php.ini, phpmyadmin, pid, plesk, ports, privilege, query, remove, restart, restore, resume, server, servers, service, set, settings, skip_name_resolve, sql, style, suspend, table, tools, update, user, with, wordpress

Flickr images for 'mysql'