• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

MYSQL

 
Ranch Hand
Posts: 96
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi all,
I have installed MySQL 4.0.15 on a Win Xp Home OS.The installation is done in the C rive and I access the MySql server like this..(local machine)
C:\mysql\bin, this connects me to the server directly but....
I want to connect to the server by giving userid and password.
I would like to know how I could do it each time I try and connect to the server.
Hope the question is well stated.

any help would be greatly appreciated.
thanx
nash
 
Ranch Hand
Posts: 3244
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
You want to connect from the command line with a user name and password...
From the bin directory type this:
mysql -u name -p password
u is the username and p is the password
Hope thats what you were looking for
 
nash avin
Ranch Hand
Posts: 96
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
hi dave,
Thanks for the prompt reply.I havent given any userid,password during my installation of mysql 4.0.15-nt.
So I would like to know how I can give it.Hope I am clear on my problem.Your reply would be appreciated.
thanks
nash
 
nash avin
Ranch Hand
Posts: 96
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
hello ,
I addition to the previous message,kindly consider this too.As per the tutorial, at the shell c mysql\bin,i type the following......
"mysql -u root", it complains with the following error,let me know how I can got about this.
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

Help would be appreciated
nash
 
Greenhorn
Posts: 19
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I think it should be:
prompt> mysql -uroot mysql
 
Dave Vick
Ranch Hand
Posts: 3244
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
nash
Try to enter it this way:
"mysql -u root -p"
It should then prompt you for the password for the user root. After you enter it you should be ok.
If you haven't set up any users and passwords yet, then the default is a user named root with no password. so when it prompts you for the password just press enter.
For info o how to then set up some users check out this section of the online manual.
Hope that helps
 
nash avin
Ranch Hand
Posts: 96
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
thanks a lot people, you were very helpful.
I am figuring out what could be done after you have told a few tips.
nash
 
reply
    Bookmark Topic Watch Topic
  • New Topic