[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

unable to start MySQL 1.4.7

Posted on 2004-11-17
9
Medium Priority
?
302 Views
Last Modified: 2006-11-17
Hi,

I have just installed, PHP, Apache, on my WinXP Pro machine. I then went to install MySQL 4.1.7, which appeared to go well...Apart from when I got to execute, and the services wouldn't start... I re installed...services started when i selected execute...

But when I went into MySQL folder and opened up winmysqladmin, which shut immediately, and a traffic light open on my tool bar with a red light showing....I right clicked on the traffic light in my toolbar, and selected start NT, and start services...are you sure you want to start? I clicked yes, and the response I got was unable to start try again in 30 seconds...

Can you help? I am very confused by all this; I just want to learn PHP for some database web design....

Wood1e
0
Comment
Question by:wood1e
  • 5
  • 4
9 Comments
 
LVL 26

Expert Comment

by:Umesh
ID: 12603374
Hi,

Take a look at this..

http://www.devside.net/web/server/windows/mysql


FOr php/mysql tutorials look at here..

http://www.freewebmasterhelp.com/tutorials/phpmysql

or download chm format manaual from php.net

Hope this helps!
0
 

Author Comment

by:wood1e
ID: 12604375
Many thanks for that, but unfortunatley, it is a tutorial for a different version of the MySQL I have, and it is the binary version as well...if I can;t get the install wizard version to work I am not going anywhere near the Binary stuff...

The second link suggest looking at the phpinfo page and scrolling down to see if MySQL is installed....on my test.php page there was this

MySQL Support enabled
Active Persistent Links  0  
Active Links  0  
Client API version  3.23.49  

I don;t know if this means MySQL is installed, or not...well it should be, as I have have installed it...

The problem is that none of this explains why I get this error message.

ANy further suggestions.

Wood1e
0
 
LVL 26

Expert Comment

by:Umesh
ID: 12605109
okie..

From control panel check whther mysql server is installed as service.. if it is there then right click & restart(stop & start). if your mysql server is not running as service then try to run as service..

From command promt go to mysql/bin

C:\mysql\bin>
then enter this command...

C:\mysql\bin>mysqld --install

Normally will get this sort of problems if MySQL server is installed as a Windows service & has problems starting if its pathname or the service name contains spaces. For this reason, avoid installing MySQL in a directory such as `C:\Program Files' or using a service name containing spaces.

Hope This Helps!
0
Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

 

Author Comment

by:wood1e
ID: 12612517
Hi,

Many thanks for that, I have MySQL installed in C:\program files\MySQL\MySQL 4.1 folder....I will uninstall and re-install to C:\ with no spaces....

And from the cmd prompt I try and run that folder location and it doesn;t recognise it....I presume thats the spaces?

I checked the services, and yes I have MySQL1 set to automatic....thats the name I gave when installing as I had an older version still in services, called MySQL, I must admit I didn;t know was there!!!!

wood1e
0
 

Author Comment

by:wood1e
ID: 12612738
Hi,

I have re-installed...C:/ with no spaces...worked on execute...I then went to MySQL command line prompt...and was able to view help, etc...

I presume this means it is working? Although this time I haven;t got a GUI, admin screen like on previous attempts to install...As I don't appear to have mysql admin-nt I shall look for it on the MySQL site...

One thing that I am concerned about I set it up as a developer servies...and I want to run database driven websites eventually is this the correct configuration? I have have installed apache websever...which I have turned off at the moment...don't want that getting in the way...

Wood1e
0
 
LVL 26

Expert Comment

by:Umesh
ID: 12612933
Hi Wood1e,

>>I presume this means it is working? Although this time I haven;t got a GUI, admin screen like on previous attempts to install...As I don't appear to have mysql admin-nt I shall look for it on the MySQL site...

Yeah it seems everything is fine, try something like this..

from command propmt go to mysql/bin folder..
C:\mysql\bin>mysql -uroot
Then you would see something like this..

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: XXXX

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>
then check the databases..

mysql>SHOW DATABASES;
+---------------+
| Database      |
+---------------+
| mysql         |
| test          |
+---------------+
2 rows in set (0.02 sec)



>>One thing that I am concerned about I set it up as a developer servies...and I want to run database driven websites eventually is this the correct configuration? I have have installed apache websever...which I have turned off at the moment...don't want that getting in the way...

Run mysql as service, and you have to spend some time in securing the mysql server.. say u have to set root password etc etc..
no probs u can run Apache as well..


0
 

Author Comment

by:wood1e
ID: 12613140
Hi,

Many thanks from the MySQL prompt I got the show databases;, although missed the semi colon first time...

Although when I go into mySQL promt, it asks me for my password, which is ok...but in the books I have looked at, the mySQLd-nt should come up with the traffice light in the tool box, and I should be prompted to insert a username and password....I don't seem to have that this time? Do you know why this is? I have tried to open mySQld-nt and a DOS screen opens up some data appears and then disappears before I can read it, and no traffice light in the tool bax indicating weather services are working...which I now know they are....

The reason I ask this is because i have just downloaded MySQL administrator, not having had much experience of DOS, so thought I would try the GUI, unfortunatley I don't have this username, that it asks for, and as I mentioned above have never been asked for it....even thought the tutorials etc say it should appear at the end of the installation of MySQL...

Sorry for the length of this question, I just feel this is the final bit I can then move on with some speed...

wood1e
0
 
LVL 26

Accepted Solution

by:
Umesh earned 2000 total points
ID: 12613526
Hi Wood1e,

Well to be honest , personally what I feel is beginer should start with command prompt which would definately help them rather than using any GUI clients for the same stuff(well it would definately save lot of time but for beginers it is good to start using command prompt).


By default mysql creates 1-2 accounts..say root with no password.. just login with root from command prompmt and create database, and after this create new user accounts allowing them to interact with this database..

Take a look at this url which shows how to create a new account in mysql & how to use etc..

http://dev.mysql.com/doc/mysql/en/Adding_users.html

If you followed the articles given in the above url and created a user account wood1e with password 123456 then try with these username/password...


Hope This Helps!

0
 

Author Comment

by:wood1e
ID: 12614264
Many thanks for all your help, it has actually helped to understand more about the installing of MySQl.

I shall take your advice and start using MySQl from the command promt, as this would also be good experience, even if somewhat different to what I am used to.

wood1e
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
Recursive SQL is one of the most fascinating and powerful and yet dangerous feature offered in many modern databases today using a Common Table Expression (CTE) first introduced in the ANSI SQL 99 standard. The first implementations of CTE began ap…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses
Course of the Month18 days, 10 hours left to enroll

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question