Basic MySQL syntax help please ...

[vfxtalk]

Hi All,

I am Extremely new to MySQL and would like to know the syntax to enter at the mysql> dos prompt on Windows machine to do the following:

- Create a user and password for a given database


Thats it :D

Also, how do i import a vBulletin db backup ??

Cheers for your time

[Black Vivi]

i dunno how to import vB bd backups, but for the dos command prompt, already conneted to mysql on it, type this:
grant all privileges on database.table to user@server identified by "password" with grant option;
replace all italics with what you want them to be
for all tables/databases type * instead of the table or database

[vfxtalk]

hi black vivi,

thatnks for that, although i can get it to work...i think im one step ahead off myself.
This is the scenario....

i have an online forum that i have downloaded and backed up. I am trying to get the exact forum setup locally on my machine, as per the config.php settings found in forum/admin/config.php.

So i figure i need to create a local environment to accept the following, and then do i db import from the .sql backup ???:


<?php
/////////////////////////////////////////////////////////////
// Please note that if you get any errors when connecting, //
// that you will need to email your host as we cannot tell //
// you what your specific values are supposed to be //
/////////////////////////////////////////////////////////////

// type of database running
// (only mysql is supported at the moment)
$dbservertype="mysql";

// hostname or ip of server
$servername="localhost";

// username and password to log onto db server
$dbusername="username";
$dbpassword="password";

// name of database
$dbname="db_vbulletin";

// technical email address - any error messages will be emailed here
$technicalemail = "me@localhost.com";

// use persistant connections to the database
// 0 = don't use
// 1 = use
$usepconnect = 0;

// which users are allowed to view the admin log
// separate each userid with a comma
$canviewadminlog = "1";

// which users are allowed to prune the admin log
// separate each userid with a comma
$canpruneadminlog = "";

?>

Any further help would be very much appreciated.

Cheers

Paul

[Black Vivi]

yea, u do