Mysqladmin 1.4

[JacKDynne]

Hmm could be a rights issue - you have all the config files using the correct info and does the account used have enough permission?

[Bads]

The problem is the "IBF" Database

She's empty

And I can't make one with mysqladmin

[JacKDynne]

Bads,

Did you run the installer?

Quote:

Installing: Step 2 - Using the Installer
An installer is provided to assist you in entering the information Invision Power Board needs to connect to your mySQL database and to create your new administrators account.

Run the "sm_install.php" file through your web browser by entering the URL to it into your browser address bar (if you have followed our example, type in http://www.domain.com/forums/sm_install.php, naturally subsituting 'domain.com' for your web address.)

That should take care of populating the db



/JD

[Bads]

Yes I run the installer and this is why I receive the message :

mySQL error: No Database Selected

[JacKDynne]

hmmm..... does your conf_global.php file have the following values filled in?

Quote:

$INFO['sql_database']  = '';
$INFO['sql_pass']  = '';

[Bads]

Quote:

Originally posted by JacKDynne@Mar 25 2004, 01:07 PM
hmmm..... does your conf_global.php file have the following values filled in?

Quote:

$INFO['sql_database']  = '';
$INFO['sql_pass']  = '';

Yes,

I have this

[war59312]

All right bads. hehe

I know what the problem is.

I'm sure you mean no right click menu in msyql. They removed it. Dont have a clue why.

So instead what you need to do is this.

Will update my guide later. Sorry about that. Forgot they did that.

Fist click run:

Then cmd.

Then:

cd C:\mysql\bin

and then run this command to create the database

mysqladmin create ibf -h localhost -u "username" -p "password" -p 3306

where it says username but your mysql username and for password put your mysql password and remove the " " marks of course

now it sould say:

Enter password: ********
mysqladmin: Unknown command: 'password here'

Its a bug. But if you run the command again you will see it was created succesfully and already exists.

Then just run the invsionboard installer sm_install.php

then for database name is ibf and type in your user name and pw

then it should work fine

if not then pw and user name where wrong and u know that by now since u would get pw wrong error above

so then you need to edit your my.cnf or my.ini file which should be in your windows or winnt directory

any more problems just ask but you should be good to go

oh and about phpmyadmin

think i will add how to install that to my guide too..going to update the whole thing this weekend

anyways download phpmyadmin and put it in your server directory

then open config.inc

and edit it to your needs...its very very well documented so you should have no problem with that...

but anyways u just have to edit line 80 and 81:

$cfg['Servers'][$i]['user'] = 'username goes here'; // MySQL user
$cfg['Servers'][$i]['password'] = 'password goes here'; // MySQL password (only needed
// with 'config' auth_type)

do not use root

thats it there is no installer

u just then open /phpmyadmin/index.php in your web browser and your good to go... basic setup anyways...just check that config.inc for all the other settings you can change...just be sure to back it up...

really should be using a php editing program that backs up automatically...

i use TextPad

[Bads]

Ok,

This is an empty Database who was created but I hvae one.

Now the problem is:

Warning: mysql_connect(): Access denied for user: 'xxxxxxx@localhost' (Using password: YES) in D:\Inetpub\wwwroot\ibf\sm_install.php on line 342

Ok,

I have to edit some lines

Now I receive this message :

Success
Your board has now been installed!

The installation process is almost complete.
The next and final step will install the template files into your database


CLICK HERE TO CONTINUE

All is ok now my friends Thanks for your help again and again

[Bads]

Not really finished


When the setup is finish and I click on the "CLICK HERE TO LOG IN!"

I have this message :

mySQL query error: DELETE FROM ib_beta_sessions WHERE running_time < 1080249293 or ip_address='xxx.xxx.x.xxx'

mySQL error: No Database Selected
mySQL error code:
Date: Thursday 25th of March 2004 05:14:53 PM

It's almost finished

[war59312]

Quote:

Originally posted by Bads@Mar 25 2004, 05:15 PM
Not really finished&nbsp;


When the setup is finish and I click on the "CLICK HERE TO LOG IN!"

I have this message :

mySQL query error: DELETE FROM ib_beta_sessions WHERE running_time < 1080249293 or ip_address='xxx.xxx.x.xxx'

mySQL error: No Database Selected
mySQL error code:
Date: Thursday 25th of March 2004 05:14:53 PM

It's almost finished&nbsp;

So did you name the datebase ib_beta then?

And you used that when you created the database and in the ivisionpower board installer right.

Have to be the same. Seems like there is a mismatch somewhere. Seems like since it says no database requried.

Even though not sure how the hell it would get to the very last window in the installer and then give that error message. Seeing as it buids the database way before then.

Just start from strach. Seeing as it takes 3secs. to install it over again.

I mean if that dont work cause its probally currupted.

And of course make sure mysql is running. :P Have done that before.

cya,
Will