 Urgent Problem With My Sql |
|
|
|
|
  |
  Feb 18 2008, 05:20 AM
Post
#1
|
|
|
Newbie  Group: Members Posts: 0 Joined: 18-February 08 Member No.: 58,037  |
well i put up my vb isntallation i was so happy but then before it was done I accendently erase my sql admin privliuse and in top of that I imported the previliuse into my computer and it erased it and now I don't have admin right in my own sql and I try evrithing making a new admin making a new database but nothing works
Any tips these is urgent man help me anyone? |
 |
 
|
|
Feb 18 2008, 06:16 AM
Post
#2
|
|
|
A computer once beat me at chess, but it was no match for me at kick boxing.  Group: [MODERATOR] Posts: 4,071 Joined: 24-July 05 From: Linix, DOS and Windows…the good, the bad and the ugly Member No.: 9,787  |
You will likely need to do a re-install.
Use phpMyAdmin to perform a backup of the data in the Tables you need to save. If it is a 'fresh' install, simply start with a fully refreshed installation. |
|
|
|
|
Feb 18 2008, 07:10 AM
Post
#3
|
|
|
Newbie Group: Members Posts: 0 Joined: 18-February 08 Member No.: 58,037 |
the installation of the vb it works but it says i don't have permission to go in my sql becuase like i said before i accendtly erased the admin well me the admin privelius of the sql so I make new members with all previliuse in the sql manager well the cpanal but it still don't let me i also make new database but i still don't work if you know what i mean
|
|
|
|
|
Feb 18 2008, 07:12 AM
Post
#4
|
|
|
Super Member Group: [HOSTED] Posts: 471 Joined: 24-September 06 Member No.: 30,489 |
Make a whole new MySql database, new members, and assign privileges, then go into your config.php file. Preferably located at ->includes->config.php
Look to where you had your old databases at, and change them to your new ones. If I understood you correctly, that should fix the problem. This post has been edited by bk2070: Feb 18 2008, 07:13 AM |
|
|
|
|
Feb 18 2008, 07:16 AM
Post
#5
|
|
|
Newbie Group: Members Posts: 0 Joined: 18-February 08 Member No.: 58,037 |
well man i already try that but he we go i be back with the results man
|
|
|
|
|
Feb 18 2008, 07:39 AM
Post
#6
|
|
|
Newbie Group: Members Posts: 0 Joined: 18-February 08 Member No.: 58,037 |
sorry for the double post but
but these is what i get MySQL Account Maintenance -------------------------------------------------------------------------------- Current Databases: flaco_flaco Users in flaco flaco_flaco (Privileges: ALL PRIVILEGES) Connection Strings Perl $dbh = DBI->connect("DBI:mysql:flaco_flaco:localhost","flaco_flaco","<PASSWORD HERE>"); PHP $dbh=mysql_connect ("localhost", "flaco_flaco", "<PASSWORD HERE>") or die ('I cannot connect to the database because: ' . mysql_error()); mysql_select_db ("flaco_flaco"); |
|
|
|
|
Feb 18 2008, 06:04 PM
Post
#7
|
|
|
Super Member Group: [HOSTED] Posts: 471 Joined: 24-September 06 Member No.: 30,489 |
Get support from vbulletin.com
They'll know it better than we do! |
|
|
|
|
Feb 19 2008, 08:37 PM
Post
#8
|
|
|
Newbie Group: Members Posts: 0 Joined: 18-February 08 Member No.: 58,037 |
wel i isntall my vb forum and these is what i get take a look at my site man
http://universal123.universal.qupis.com/forum/ |
|
|
|
|
Feb 19 2008, 09:50 PM
Post
#9
|
|
|
A computer once beat me at chess, but it was no match for me at kick boxing. Group: [MODERATOR] Posts: 4,071 Joined: 24-July 05 From: Linix, DOS and Windows…the good, the bad and the ugly Member No.: 9,787 |
That explains what the DB connection should be based on the information in mySql, but what does the DBconnect Config file for the vb install look like?
Post it here without your password, of course. |
|
|
|
|
Feb 19 2008, 11:25 PM
Post
#10
|
|
|
Newbie Group: Members Posts: 0 Joined: 18-February 08 Member No.: 58,037 |
like these CODE <?php /*======================================================================*\ || ###### |