Login to OSTICKET DB Via mysql is not possible.
If you are requesting help then we are going to need more information. What have you done recently? Is this a first attempt at an install? Have you applied a MOD? What is the exact error message you are getting? Are you on your own server or are you hosted?
I am not able to see OSTICKET DB as a running DB in mysql
mysql> show databases;
+--------------------+
| Database |
| information_schema |
| test |
2 rows in set (0.00 sec)
I am not able to see OSTICKET DB as a running DB in mysqlmysql> show databases;+--------------------+| Database |+--------------------+| information_schema | | test | +--------------------+2 rows in set (0.00 sec)
Only a few possibilities here, either the db has been named 'test' instead of 'tickets', the DB didn't get setup at all, or you are on the wrong server for the 'show databases;' command.
Most likely in MySQL with wrong user, which does NOT have privileges to the ostickets DB.
Ah, yes that could be it too... I'm always root so I totally forgot about that possibility.
I have logged in as mysql
mysql> SELECT USER();
+-----------------+
| USER() |
| mysql@localhost |
1 row in set (0.00 sec)
and probably the mysql user you use has no rights to the database.
I would
- check what database users are on the system
select user from mysql.user;
and
- check what rights you have
show grants for mysql
Post the results.
Best
T.
