Programming Forums > Web Development and Design > Other Web Development Languages

paulchwd · Feb 24th, 2007, 4:04 PM

Hello All

I just downloaded and installed MySQl and am having a slight problem:

I went through the detailed setup and was never asked to set a root password or user and now when i open up the MySQL command line i am prompted to enter a root password. I tried just pushing enter and it exited.

(Toggle Plain Text)

The Details:

MySQl 4.1 for windwos Xp Pro SP2 (i used the windows X86 zip/installer file)

Detailed Setup Details:

Developer Machine
Multifunction Database  (Both InnoDb and MyIsam)
InnoDb path \MySql InnoDB Datafiles\
Decission Support (DSS) / OLAP (20 concurrent connections assumed)
Disabled TCP/IP
Standard Character Set
Do not install as a windows service
Include Bin Directory in Windows PATH

At this point it says push execute to execute ......
and it finishes ok

Nowhere am I prompted to enter a root password or user

milot · Feb 24th, 2007, 4:53 PM

Did you tried XAMPP for Windows? if not, give it a try (it's free):

http://www.apachefriends.org/en/xampp.html

paulchwd · Feb 24th, 2007, 4:55 PM

Quote:

Originally Posted by milot

Did you tried XAMPP for Windows? if not, give it a try (it's free):

http://www.apachefriends.org/en/xampp.html

Thanks a lot, looks interesting and useful, but its not for me.

PhilBon · Feb 24th, 2007, 7:18 PM

I know when I installed MySQL that it was like a normal install process for a program and during one of the windows I was prompted for a root password as well as what kind of MySQL Server it would be like an up and running or developing machine. I would uninstall it and reinstall it again to try and have different results, if need be let me know and I'll install it myself and make you something you can work off of.

paulchwd · Feb 25th, 2007, 12:27 AM

Update:

I uninstalled MySQl 4.1 and installed 5 (5.027 i think) and when the configuration thingy (for lack of a better word) came up i applied all the same settings as before, (except i chose strict mode) if i deselected create as service, i was not prompted to enter a root password, when i did select create as service i was prompted to create a root password.

Infinite Recursion · Feb 26th, 2007, 8:37 AM

You can always change the root password from within MySql if need be.

http://dev.mysql.com/doc/refman/5.0/...rmissions.html

pegasus001 · Feb 27th, 2007, 5:25 AM

Did you use msi packages to install, if you didnt than go and download the windows installer packages from MysqlAb. There is a configuration utitlity there that you can use to reconfigure your settings. But i had some problems with it couse it didnt apply the setting because my antivirus was on, so disable your antivirus software and retry.

paulchwd · Feb 27th, 2007, 10:31 AM

Thanks, i did install is through msi, i installed it as a service this time and it works thanks all.

Can you please take a look at my other posting (MySQl Error) its in this same 'room' thanks

Feb 24th, 2007, 4:04 PM	#1
paulchwd Hobbyist Programmer Join Date: Mar 2005 Posts: 139 Rep Power: 4	MySQl simple problem Hello All I just downloaded and installed MySQl and am having a slight problem: I went through the detailed setup and was never asked to set a root password or user and now when i open up the MySQL command line i am prompted to enter a root password. I tried just pushing enter and it exited. (Toggle Plain Text) The Details: MySQl 4.1 for windwos Xp Pro SP2 (i used the windows X86 zip/installer file) Detailed Setup Details: Developer Machine Multifunction Database (Both InnoDb and MyIsam) InnoDb path \MySql InnoDB Datafiles\ Decission Support (DSS) / OLAP (20 concurrent connections assumed) Disabled TCP/IP Standard Character Set Do not install as a windows service Include Bin Directory in Windows PATH At this point it says push execute to execute ...... and it finishes ok Nowhere am I prompted to enter a root password or user The Details: MySQl 4.1 for windwos Xp Pro SP2 (i used the windows X86 zip/installer file) Detailed Setup Details: Developer Machine Multifunction Database (Both InnoDb and MyIsam) InnoDb path \MySql InnoDB Datafiles\ Decission Support (DSS) / OLAP (20 concurrent connections assumed) Disabled TCP/IP Standard Character Set Do not install as a windows service Include Bin Directory in Windows PATH At this point it says push execute to execute ...... and it finishes ok Nowhere am I prompted to enter a root password or user

Feb 26th, 2007, 8:37 AM	#6
Infinite Recursion Programming Guru Join Date: Jul 2004 Location: United States Posts: 3,467 Rep Power: 8	You can always change the root password from within MySql if need be. http://dev.mysql.com/doc/refman/5.0/...rmissions.html __________________ http://jasonpowers.net "There are a thousand hacking at the branches of evil to one who is striking at the root."

Feb 27th, 2007, 5:25 AM	#7
pegasus001 Hobbyist Programmer Join Date: Nov 2006 Location: 163H Posts: 213 Rep Power: 2	Did you use msi packages to install, if you didnt than go and download the windows installer packages from MysqlAb. There is a configuration utitlity there that you can use to reconfigure your settings. But i had some problems with it couse it didnt apply the setting because my antivirus was on, so disable your antivirus software and retry. __________________ You never test the depth of a river with both feet. The believer is happy. The doubter is wise. Free speech carries with it some freedom to listen. The next generation will always surpass the previous one. It`s one of the never ending cycles of life.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
MySQL Problem	Chris Weimer	Other Web Development Languages	8	Jun 9th, 2006 5:02 PM
EXTREMELY simple problem	d_heyzie	C++	15	Feb 2nd, 2006 11:32 PM
Simple Perl / MySQL Problem.. pls help!	domquemo	Perl	0	Jan 11th, 2006 4:08 AM
Problem Inserting Values into mySQL from PHP	stakeknife	PHP	1	Mar 23rd, 2005 8:45 AM
repaint() problem in very simple program	dotred	Java	1	Mar 17th, 2005 5:17 AM

Feb 24th, 2007, 4:53 PM	#2
milot Programmer Join Date: Nov 2006 Location: Kosov�/Prishtin� Posts: 47 Rep Power: 0	Did you tried XAMPP for Windows? if not, give it a try (it's free): http://www.apachefriends.org/en/xampp.html

Feb 24th, 2007, 7:18 PM	#4
PhilBon Hobbyist Programmer Join Date: Nov 2005 Posts: 172 Rep Power: 3	I know when I installed MySQL that it was like a normal install process for a program and during one of the windows I was prompted for a root password as well as what kind of MySQL Server it would be like an up and running or developing machine. I would uninstall it and reinstall it again to try and have different results, if need be let me know and I'll install it myself and make you something you can work off of.

Feb 25th, 2007, 12:27 AM	#5
paulchwd Hobbyist Programmer Join Date: Mar 2005 Posts: 139 Rep Power: 4	Update: I uninstalled MySQl 4.1 and installed 5 (5.027 i think) and when the configuration thingy (for lack of a better word) came up i applied all the same settings as before, (except i chose strict mode) if i deselected create as service, i was not prompted to enter a root password, when i did select create as service i was prompted to create a root password.

Feb 27th, 2007, 10:31 AM	#8
paulchwd Hobbyist Programmer Join Date: Mar 2005 Posts: 139 Rep Power: 4	Thanks, i did install is through msi, i installed it as a service this time and it works thanks all. Can you please take a look at my other posting (MySQl Error) its in this same 'room' thanks

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Programming Forums > Web Development and Design > Other Web Development Languages

MySQl simple problem