Table of Contents
1. Why am I getting the Access denied for user message, when trying to connect to MySQL DB with a PHP script?
2. Why am I getting Access denied for user: 'user_name@localhost'?
3. How can I make MySQL user friendly? What program can I use as an Interface?
4. I forgot my port number. Can you help me find my port number?
5. I cannot login to mysql.iu.edu using the port number you provided.
6. I got an error 28 from table handler message. It seems to be related to not having enough space. What should I do?
Why am I getting the Access denied for user message, when trying to connect to MySQL DB with a PHP script in my Veritas account?
The message like the following,
Warning: Access denied for user: 'newUser@hyperion.ucs.indiana.edu' (Using password: YES) in /ip/account_name/wwws/index.php on line 5
means that the user, newUser, does not have the right (privilege) to access your MySQL Database from hyperion.ucs.indiana.edu (one of the server among the veritas server group).
To fix it, grant the access rights to the user to the DB named firstDB, using the following command (replace firstDB with your DB name, newUser with your user name, and password with the password for the newUser):
mysql> GRANT select,insert,update,delete on firstDB.*
-> to newUser@'129.79.78.%' IDENTIFIED BY 'password';
Please note that you need to use the single quotation marks around the IP address and the password.
If you are still getting an error, you need to modify the user table of the mysql DB following the instuctions given at Workaround Solution
Why am I getting an error message like Access denied for user: 'user_name@localhost'?
You may get this error message, after logging in to your MySQL account using SSH and with the command,
mysql -u user_name -p
You are getting this error , because the user, user_name, does not have the right to access your MySQL DB. To fix it, you need to create a user, using the following command (Replace firstDB with your database name, user_name with your user name, and password with the user's password).
mysql> GRANT ALL ON *.* to user_name@localhost IDENTIFIED BY 'password';
How can I make MySQL user friendly? What program can I use as an Interface?
You can use a web-based MySQL administration program PhpMyAdmin . You can easily install it in your Veritas or Champion account .
I forgot my port number. Can you help me find my port number?
The .my.cnf file contains your port number. The .my.cnf file is located in the login directory of your account on Triton (mysql.iu.edu) or Callisto (mysql-test.iu.edu).
I cannot login to mysql.iu.edu with the port number you provided.
You should not use the port number you've got with the passwords, when you are making an SSH connection in order to log in to your account on mysql.iu.edu. You should just let the SSH program set the port number itself.
The mysql port number is the port number for your mysql server process, which should be used by your web applications on Veritas or Champion in order to access your mysql server as given in this example codes.
I got an error 28 from table handler message. It seems to be related to not having enough space. What should I do?
There are no disk quotas enabled on mysql.iu.edu or mysql-test.iu.edu. It may be that your .my.cnf file needs some adjustment to accommodate more temporary tables during queries, etc. The .my.cnf file is located in the login directory of your account on Triton (mysql.iu.edu) or Callisto (mysql-test.iu.edu). The documentation for mysql on Triton is at: http://www.indiana.edu/~mgrmysql/reference/ |
