Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

New to MySQL... please HELP!

Status
Not open for further replies.

term

Technical User
Apr 15, 2002
1
CA
I am new to MySQL.. I just installed it on my windows 98 (upgrading soon, dont make fun of me :( ) and im trying some first step processes.

I am learning out of a book called PHP fast and easy web development. THe book says this is the first step.

It says open a ms DOS prompt and type:

cd c:\mysql\bin

then type:

mysqld --standalone

when i type the standalone part i get this error:

Cannot initialize innoDB as 'innodb_data_file_path' is not set. If you do not want to use transactional innoDB tables, add a line
skip-innodb
to the [mysqld] section of unit parameters in your my.cnf or my.ini. If you want to use InnoDb tables, add for example, innodb_data_file_path = /mysql/data/ibdata1:20M
But to get good performance you should adjust for your hardware the InnoDb setup options listed at 7.6 at mysql.com/docs


What do I do.. Someone please help?!

Thank you for any information you provide.

Term
 
Go back to c:\mysql\bin and look for a file called mysqladmin.exe. This will load the mysql server. It puts a little traffic light in your tray so you know if it's running. Mysqladmin also let's you check out the configuration and run reports of the databases. There is also a program you can down load called mysqlgui which is a graphical interface client for mysql. It let's you create databases, users and set permissions. If you plan on using programs or scripts that use mysql, you will also need to make sure you have ODBC or MyODBC installed. You can get MyODBC from where you got MySQL. Getting back to your question, It looks like mysqld is not running or you skipped something in the install/setup process. I think doing things from the command line is great and sometimes a little faster but if you are trying to learn then you should be able to see what's going on.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top