Troubleshooting common Legacy MySQL for Webserve issues

Note:
Support for the Legacy MySQL for Webserve environment is ending May 31, 2018. If you have a Legacy MySQL account, you should migrate your service to the New MySQL for Webserve environment before that date. For more, see Migrate from Legacy to New MySQL for Webserve service.
Important:
On Webserve, the default version of PHP is 7.1; however, PHP 5.6 will still be available until it is retired at the end of December 2018. Webtest servers are already using PHP 7.1. For help specifying which version of PHP to use, see PHP server-side scripting language.

On this page:


Correcting common errors

Access denied for user

The error message is similar to:

 Warning: Access denied for user: 'username@lux.uits.indiana.edu' (Using password: YES) in /ip/account/wwws/index.php on line 5

This means that the user, in this case username, does not have the privileges necessary to access the MySQL database from lux (one of several backend webservers).

Correction

Grant privileges to the username specified in the error message. Instructions on how to grant privileges can be found at Legacy MySQL for Webserve privileges.

Access denied for user: username@localhost

This error may occur when attempting to execute the following command on the MySQL server:

 mysql -u username -p

The access denied error message indicates that username as specified in the command above does not have privileges to access the database.

Correction

Grant the username the appropriate privileges. For example:

 mysql> GRANT ALL ON *.* to username@localhost IDENTIFIED BY 'password';

You may specify which privileges are set by replacing ALL with the privileges that should be granted. You may also restrict privileges to a specific database rather than all by substituting *.* with the name of the database/table for which these privileges should apply.

For more about granting privileges and the various options available, see Legacy MySQL for Webserve privileges.

Unblock with mysqladmin flush-hosts

The error message is similar to:

Error connecting to MySQL server. Host 'lux.uits.indiana.edu' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts'

Correction

Log into your account on the MySQL server (mysql.iu.edu), and stop and restart your MySQL server. For more, see Starting/stopping the MySQL server for your account.

Error 28 from table handler/not enough space

This error message is usually accompanied by a message that indicates a space issue.

Correction

While this error message indicates a space issue, there are no disk quota enabled on mysql.iu.edu or mysql-test.iu.edu. Your master configuration file .my.cnf might need to be adjusted to accommodate more temporary tables during queries, etc. For assistance in making changes in your master configuration file, .

Account-related issues

Forgotten port number

Contact Web Services Support for assistance.

Unable to log into mysql.iu.edu with the port number provided

Your web applications use the MySQL port number to access your MySQL server on Webserve. When making an SSH connection, such as with the PuTTY client, a port number (22) is referenced; do not change it. Changing the port number will prevent you from being able to log into your account.

This is document bfor in the Knowledge Base.
Last modified on 2018-04-11 08:36:35.

  • Fill out this form to submit your issue to the UITS Support Center.
  • Please note that you must be affiliated with Indiana University to receive support.
  • All fields are required.

Please provide your IU email address. If you currently have a problem receiving email at your IU account, enter an alternate email address.

  • Fill out this form to submit your comment to the IU Knowledge Base.
  • If you are affiliated with Indiana University and need help with a computing problem, please use the I need help with a computing problem section above, or contact your campus Support Center.

Please provide your IU email address. If you currently have a problem receiving email at your IU account, enter an alternate email address.