Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
adding more host???
- Thread starter tempsup
- Start date
use the GRANT command
example
GRANT ALL ' ALL stands for all privileges
ON dbname.* '* stands for all tables
to user@'hostname'
IDENTIFIED BY "password"
if the username does not exist in the user table MySQL will create a new user.
The hostname can also be an IP address.
I recommend you read this
Bye
QatQat
Life is what happens when you are making other plans.
example
GRANT ALL ' ALL stands for all privileges
ON dbname.* '* stands for all tables
to user@'hostname'
IDENTIFIED BY "password"
if the username does not exist in the user table MySQL will create a new user.
The hostname can also be an IP address.
I recommend you read this
Bye
QatQat
Life is what happens when you are making other plans.
- Status