unable to start MySQL 1.4.7

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
wood1eAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

UmeshMySQL Principle Technical Support EngineerCommented:
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
wood1eAuthor Commented:
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
UmeshMySQL Principle Technical Support EngineerCommented:
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
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

wood1eAuthor Commented:
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
wood1eAuthor Commented:
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
UmeshMySQL Principle Technical Support EngineerCommented:
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
wood1eAuthor Commented:
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
UmeshMySQL Principle Technical Support EngineerCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
wood1eAuthor Commented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.