VB Test Failure

[Aquaticedge]

I'm trying to run the VB test to see if I can run the software on my server, Everything passes but the mySQL.. Does this mean mySQL is out of date (Currently installed and Configured is 4.1) or How would I change the mySQL Permissions.. I'm looking to buy a license This coming Month

I get the error:

"vBulletin requires that the mysql username has create, select, update, insert, delete, alter and drop privledges, contact your host and ask them to adjust these privledges."

[Lats]

Did you contact your host about this, as per the error?

[Aquaticedge]

Did you contact your host about this, as per the error?

I should have said, I am the host

[Lats]

Okay, you need to grant those privileges to the user assigned to the database.

[SNN]

GRANT ALL TO 'user'@'localhost' ON *.* IDENTIFIED BY 'password'

Grant yourself the privileges as such, then.

[Aquaticedge]

GRANT ALL TO 'user'@'localhost' ON *.* IDENTIFIED BY 'password'

Grant yourself the privileges as such, then.

Please forgive my ignorance, but I dont even know where to see the privliges for mySQL

[Lats]

When you say, you are the host, are you on a managed server/vps or on your own?

Check the docs on GRANT...

http://dev.mysql.com/doc/refman/5.1/en/grant.html

[Aquaticedge]

When you say, you are the host, are you on a managed server/vps or on your own?

Check the docs on GRANT...

http://dev.mysql.com/doc/refman/5.1/en/grant.html

I Own the server, I'm trying to figure out what to edit in the mysql For the permissions, I think I know what to edit, but need to know where to edit

[SNN]

In SSH (or console) type mysql -u root -p, and type your MySQL password.
Replace user in the code that I provided above with a username you'd like, same with the password.
So, something like this will happen:

[root@localhost ~]# mysql -u root -p
Enter Password: yourpasswordhere
mysql> GRANT ALL TO 'admin'@'localhost' ON *.* IDENTIFIED BY 'megaPassword';
1 row(s) affected. (0.01 sec)
mysql>

If you don't get something along the lines of that... well yeah. something probably went wrong.

[Aquaticedge]

This is Done in the mySQL Command line Client?p>

In SSH (or console) type mysql -u root -p, and type your MySQL password. </p>Replace user in the code that I provided above with a username you'd like, same with the password.
So, something like this will happen:

[root@localhost ~]# mysql -u root -p
Enter Password: yourpasswordhere
mysql> GRANT ALL TO 'admin'@'localhost' ON *.* IDENTIFIED BY 'megaPassword';
1 row(s) affected. (0.01 sec)
mysql>

If you don't get something along the lines of that... well yeah. something probably went wrong.

[Aquaticedge]

Ok, this is the Error in the VB_test.php

[Wayne Luke]

Update the client in your PHP. If you're using MySQL 5 or higher then you should be using PHP 5 or higher.

[Aquaticedge]

I am Using SQL 4.1, and PHP 4.3, I cant get php 5 to configure right

[beishe8]

As I see on the image the biggest problem is that you don't have the necessary permissions to do something with the database.
Delete it and create it again with all the permissions.

[Aquaticedge]

Ok, I ran through Everything, I know I have the right permissions... yet I'm still getting the database issues