|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
|
|||
|
|||
|
hi frnds
can anyone tell me the process of creating a client for a dedicated server . i have tried inserting the host,user,password filds in the user table of the server and i have installed mysql 4.1 on the client machine also.. i mean how to get access of the server(a dedicated machine) from a client machine???? have tried running accessing the server from client by "\~\bin\mysql -h hostname -u username -p" but it gives error that host "ost " not found..... i m confused how to work it out.... plz do help me in it.. thanx |
|
#2
|
||||
|
||||
|
You need to grant access in MySQL before users can connect.
Try this command: GRANT ALL ON *.* TO user IDENTIFIED BY 'password' But note, this will allow that user access to everything! If you want to restrict to a certain database, use dbname.*... If you want to restrict to a certain table, use dbname.tablename... If you want to restrict certain rights, read the documentation. |
|
#3
|
|||
|
|||
|
thanx
thanx a lot
it helped me a lot |
![]() |
| Viewing: Dev Articles Community Forums > Databases > MySQL Development > how to create a client on different machine |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|