Unable to connect to MySQL server. Possibly invalid login info.

Sooty

I'm getting this error message during installation

"Unable to connect to MySQL server. Possibly invalid login info. "

myphpadmin shows;

# Server version: 5.0.67-community-log

# Protocol version: 10

# Server: Localhost via UNIX socket

# MySQL client version: 4.1.22

# Used PHP extensions: mysql

I've created DB through Cpanel and added a user.

Table prefix and hostname are correct, they are the same as I have used for oscommerce installs on the same server/hosting account.

User is added to DB correctly.

I've created 3 different DB's and 2 new users trying to get it to work and still the same problem.

Any ideas where I look next??

Sooty

Jmurrayga

Stupid fix but found it twice with two different CMS softwares and Osticket.

Verify your mysql hostname. (obviously)

The "stupid fix" for me as been the fact that I have a tendency to Copy/paste the hostname from my cpanel. Everytime it puts an extra space on the end. Everytime it causes it to fail to connect to my mysql server.

Annoying and maybe I'm the only one that has the problem with it, but worth a shot to see if your getting an extra character as well.

Sooty

have just checked all entries for stray spaces and it isn't that.

Will try anything at the moment!

Sooty

This is now fixed.

I'd assumed that entering the "table prefix" removed the need for including th "ost_" in front of database and user names!

This is now closed, hopefully will be helpful to other new user in the future!

Sooty

ben0ben

Hi all,

As you said I'm new user

and I've the same problems but i didn't understand your answer sooty

my infos are quite simple ;)) : localhost, root, ""

I'm under wamp5

First,

I put under comment this line in index.php (in "setup" folder)

//$f = array('type'=>'string', 'required'=>1, 'error'=>'password required');

cause i've no password, and the script ask me one ....

Then

I'm getting this message "Unable to connect to MySQL server. Possibly invalid login info. "

I've try this

if(mysql_connect("localhost", "root", "")) echo "OK mysql connexion OK";

in index.php (in "setup" folder)

and "mysql connexion OK" appears ....

so the problem don't come from my "Possibly invalid login info" ...

Any ideas ?

sooty, can you explain how you've done ?

I really want to try this tool ...

tks in advance

Sooty

Hi Ben

I'll be honest, I've got no idea what you have done, You appear to be working at a higher level than me already!.

My hosting uses cpanel which has direct access to MySQL databases.

I created the database in there and named it.

for example;

sootyhost_sample

then linked a user to it

example

sootyhost_testdriver

when installing OSticket

initially I used

sootyhost_

localhost

sample

testdriver

password

when it should have been;

sootyhost_

localhost

sootyhost_sample

sootyhost_testdriver

password

I didn't need to get involved with script at all.

Maybe someone else can help???

Sooty

ben0ben

Now it's ok ....

but it's quite incredible that the database and the login must have the same prefix ...:

normally a prefix is done to recognize easly some tables in a database that includes many tables ....

It's not done to do an auto-installation a nightmare ... : anyway ....

Osticket needs (as you said) parameters like this

prefix_user

prefix_database

so i created a new mysql user

It's easy to do this by copying these lines in SQL command of your phpmyadmin

(GRANT ALL PRIVILEGES ON *.* TO 'ost_root'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;)

and now with

prefix: ost_

hostname: localhost

database: ost_helpdesk

Username: ost_root

Password: password

it's working ...

I don't know if the prefix is necessary for the username AND the database ....

but by following what you've done ... it's ok

I'm almost thinking that this stuff is done to submit for a professional installation ...

anyway, now it's ok

thanks sooty for your help ;)

ready for testing !!!

It seems great !

regards

Sooty

Hi Ben

don't think it's done to sell "Pro" services, I just think they assume we are smarter than we actually are!

regards

Sooty

peter

osTicket doesn't require database names or user-names in any particular format - whatever is entered is used. However, password is required for security reasons.

Ben - The code is open source - feel free to prove your case.

Kelli

As to the database name needing a "prefix" a lot of hosts, depending on the MySQL configuration, require the database name to be prefixed by the user accessing the database.

e.g. you create a user 'ost' and assign it privileges on the database 'osticket' if the database is shown as belonging to that MySQL user, then depending on how privilege assignment is configured, you may need to enter the database name as 'ost_osticket' in order to connect.

Alternately, some hosts require you to prefix the username and database name both with your linux user name, e.g. db: 'kelli_osticket' and user: 'kelli_ost'.

Or you could simply enter user 'ost' and database 'osticket'.

It all depends on the web server configuration and has nothing to do with osTicket.

cPanel or phpMyAdmin should tell you what you need.

mespenlaub

GoDaddy Setting for osTicket Help

I am completely lost right now and on the last step. Here is my information.

MySQL Database Information

Status

Name.db.6229273.hostedresource.com

Database Name Version.0

Description

Name

Now what settings do I need to put in

MySQL (version 4.4+) is the only database supported at the moment.

Unable to connect to MySQL server. Possibly invalid login info.

MySQL Table Prefix:

MySQL Hostname:

MySQL Database:

MySQL Username:

MySQL Password:

ntozier

Please don't cross post the same issue in multiple places.