MySQL Help
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me

The Shed is going Social! Join us on FaceBook and Twitter and chime in on the conversation.

Go Back   Dev Shed ForumsDatabasesMySQL Help

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old January 25th, 2013, 07:00 AM
carlo1937# carlo1937# is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Jan 2013
Posts: 5 carlo1937# User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 33 m 24 sec
Reputation Power: 0
Cannot connect to mysql first time

I've installed mysql 5.5 to work with php.From the workbench I tried to connect first time, impossible.I've allowed the program through the firewall,nothing.I read all the tutorials on the subject, still I don't understand one thing. How do I set admin privileges if I cannot connect?
If I run the scripts on the command prompt I get error. Some tutorials talk about installing Wamp or other software, why do I need more junk on my pc to have mysql
working? And when they talk about the shell, where is the shell on the workbench? If I go to start, MySQL,MySQL Server 5.5.,Command Line Prompt it disappears immediately, so where do I type the script?
I like my sql express and management studio better, do I need mysql to work with php?Getting frustrated.
Thanks for your help.

Reply With Quote
  #2  
Old January 25th, 2013, 09:12 AM
f_razzoli f_razzoli is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Jan 2013
Location: Italy
Posts: 36 f_razzoli User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 4 h 37 m 48 sec
Reputation Power: 1
You don't need any junk, unless you want them to solve problems for you

Please, calm down I don't understand exactly what you can or can not do.

1) Did you start MySQL? (see running processes)
2) Are you able to connect to MySQL via the mysql command-line client? If you didn't change default settings (the port number) you start it this way:
mysql -u root -p
the it asks you the password for root, which is an empty string at the moment, so just press enter.

Reply With Quote
  #3  
Old January 25th, 2013, 05:57 PM
E-Oreo's Avatar
E-Oreo E-Oreo is offline
Lost in code
Click here for more information.
 
Join Date: Dec 2004
Posts: 7,931 E-Oreo User rank is General 91st Grade (Above 100000 Reputation Level)E-Oreo User rank is General 91st Grade (Above 100000 Reputation Level)E-Oreo User rank is General 91st Grade (Above 100000 Reputation Level)E-Oreo User rank is General 91st Grade (Above 100000 Reputation Level)E-Oreo User rank is General 91st Grade (Above 100000 Reputation Level)E-Oreo User rank is General 91st Grade (Above 100000 Reputation Level)E-Oreo User rank is General 91st Grade (Above 100000 Reputation Level)E-Oreo User rank is General 91st Grade (Above 100000 Reputation Level)E-Oreo User rank is General 91st Grade (Above 100000 Reputation Level)E-Oreo User rank is General 91st Grade (Above 100000 Reputation Level)E-Oreo User rank is General 91st Grade (Above 100000 Reputation Level)E-Oreo User rank is General 91st Grade (Above 100000 Reputation Level)E-Oreo User rank is General 91st Grade (Above 100000 Reputation Level)E-Oreo User rank is General 91st Grade (Above 100000 Reputation Level)E-Oreo User rank is General 91st Grade (Above 100000 Reputation Level)E-Oreo User rank is General 91st Grade (Above 100000 Reputation Level)  Folding Points: 945 Folding Title: Novice Folder
Time spent in forums: 2 Months 7 h 48 m 54 sec
Reputation Power: 7053
WAMP (usually) stands for Windows-Apache-MySQL-PHP. Since you're trying to connect MySQL and PHP, I'm assuming you're doing web development, in which case you would need a web server too (hence Apache). If you're not doing web development, then you don't need Apache.

The reason many tutorials recommend something like XAMPP or WAMP is because PHP and MySQL can be difficult and confusing to install on Windows. Although they are compatible with Windows, they are generally far easier to use on a Linux based system. WAMP and XAMPP are bundled installers that install pre-configured versions of PHP, MySQL and Apache. The pre-configured versions are already set up to work with each other correctly. If you install them separately, then you have to do the configuration on your own. I'm not sure about WAMP, but XAMPP also includes a control panel for starting and stopping the services as well; otherwise you have to take care of doing that manually on your own too.

If your primary goal is to learn how to program, and not to learn how to do server administration, then I highly recommend using XAMPP instead of trying to install each program separately yourself. XAMPP is not suitable for production servers, but it is extremely useful for Windows development servers.

You do not need MySQL to program in PHP, unless of course your goal is to use PHP to access a MySQL database. You also do not need a web server to program in PHP, unless your goal is to build a website.

If you are getting error messages you should post those, as they probably contain pretty valuable information.
__________________
PHP FAQ
How to program a basic, secure login system using PHP

Quote:
Originally Posted by Spad
Ah USB, the only rectangular connector where you have to make 3 attempts before you get it the right way around

Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesMySQL Help > Cannot connect to mysql first time

Developer Shed Advertisers and Affiliates



Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 


Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.

© 2003-2013 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap