rant: f00kING MYSQL WHY WONT YOU WORK ARGH.

[NuclearFusi0n]

GODDAMN YOU MYSQL DAMN YOU!!!!1111111

it's almost 3 in the damn morning and i cant get mysql to work correctly. when i run mysqld at the command prompt, it does absolutely nothing, it just returns to the prompt, and MySQL doesn't work

 

[Zugzwang152]

edit: got fixed bleh sorry

 

[kt]

Are you just ranting or are you asking for help?

 

[klah]

DL Oracle 9i Personal Edition.

 

[NuclearFusi0n]

Originally posted by: kt
Are you just ranting or are you asking for help?

sorta both....i'll probably wake up tomorrow and just figure it out or something

 

[kt]

Originally posted by: NuclearFusi0n

Originally posted by: kt
Are you just ranting or are you asking for help?

sorta both....i'll probably wake up tomorrow and just figure it out or something

well, in case you feel suddenly inspired.. mysqld is not supposed to do anything. It's just to start up the mysql daemon. If you want to configure or make changes to mysql, you need to do it thru mysqlclient. do you have the linux or the win32 version?

 

[NuclearFusi0n]

Originally posted by: kt

Originally posted by: NuclearFusi0n

Originally posted by: kt
Are you just ranting or are you asking for help?

sorta both....i'll probably wake up tomorrow and just figure it out or something

well, in case you feel suddenly inspired.. mysqld is not supposed to do anything. It's just to start up the mysql daemon. If you want to configure or make changes to mysql, you need to do it thru mysqlclient. do you have the linux or the win32 version?

the daemon wont start is what i'm saying...

 

[kt]

Originally posted by: NuclearFusi0n

Originally posted by: kt

Originally posted by: NuclearFusi0n

Originally posted by: kt
Are you just ranting or are you asking for help?

sorta both....i'll probably wake up tomorrow and just figure it out or something

well, in case you feel suddenly inspired.. mysqld is not supposed to do anything. It's just to start up the mysql daemon. If you want to configure or make changes to mysql, you need to do it thru mysqlclient. do you have the linux or the win32 version?

the daemon wont start is what i'm saying...

win32 or linux version?

 

[NuclearFusi0n]

Originally posted by: kt

Originally posted by: NuclearFusi0n

Originally posted by: kt

Originally posted by: NuclearFusi0n

Originally posted by: kt
Are you just ranting or are you asking for help?

sorta both....i'll probably wake up tomorrow and just figure it out or something

well, in case you feel suddenly inspired.. mysqld is not supposed to do anything. It's just to start up the mysql daemon. If you want to configure or make changes to mysql, you need to do it thru mysqlclient. do you have the linux or the win32 version?

the daemon wont start is what i'm saying...

win32 or linux version?

win32

 

[NuclearFusi0n]

http://upload.ipaska.net/112002/MySQLerror.png
copy paste the URL into address bar

 

[nagger]

Have you tried rebooting?

 

[NuclearFusi0n]

Originally posted by: nagger
Have you tried rebooting?

yes

 

[NuclearFusi0n]

error log shows:

021122 3:11:13 MySql: Table 'mysql.host' doesn't exist

 

[kt]

win32

Ok, here are some more questions.

Do you have the my.ini file configured correctly? It should be in your main Windows directory.
Did you try to start MySQL with Winmysqladmin.exe file instead?

 

[NuclearFusi0n]

Originally posted by: kt

win32

Ok, here are some more questions.

Do you have the my.ini file configured correctly? It should be in your main Windows directory.
Did you try to start MySQL with Winmysqladmin.exe file instead?

C:\Windows\my.ini

[WinMySQLAdmin]
Server=C:/Program Files/MySQL/bin/mysqld.exe

[mysqld]
basedir=C:/Program Files/MySQL/
datadir=C:/The Site/
skip-innodb

yes, tried winmysqladmin, no go, it just adds to the error log

 

[NuclearFusi0n]

sleep time, nite nite, help me out

 

[kt]

Originally posted by: NuclearFusi0n

Originally posted by: kt

win32

Ok, here are some more questions.

Do you have the my.ini file configured correctly? It should be in your main Windows directory.
Did you try to start MySQL with Winmysqladmin.exe file instead?

C:\Windows\my.ini

[WinMySQLAdmin]
Server=C:/Program Files/MySQL/bin/mysqld.exe

[mysqld]
basedir=C:/Program Files/MySQL/
datadir=C:/The Site/
skip-innodb

yes, tried winmysqladmin, no go, it just adds to the error log

Try:
Server=C:/Program Files/MySQL/bin/mysqld-nt.exe

 

[NuclearFusi0n]

Originally posted by: kt

Originally posted by: NuclearFusi0n

Originally posted by: kt

win32

Ok, here are some more questions.

Do you have the my.ini file configured correctly? It should be in your main Windows directory.
Did you try to start MySQL with Winmysqladmin.exe file instead?

C:\Windows\my.ini

[WinMySQLAdmin]
Server=C:/Program Files/MySQL/bin/mysqld.exe

[mysqld]
basedir=C:/Program Files/MySQL/
datadir=C:/The Site/
skip-innodb

yes, tried winmysqladmin, no go, it just adds to the error log

Try:
Server=C:/Program Files/MySQL/bin/mysqld-nt.exe

nope, that didn't do it

 

[n0cmonkey]

Originally posted by: NuclearFusi0n

Originally posted by: kt

Originally posted by: NuclearFusi0n

Originally posted by: kt

win32

Ok, here are some more questions.

Do you have the my.ini file configured correctly? It should be in your main Windows directory.
Did you try to start MySQL with Winmysqladmin.exe file instead?

C:\Windows\my.ini

[WinMySQLAdmin]
Server=C:/Program Files/MySQL/bin/mysqld.exe

[mysqld]
basedir=C:/Program Files/MySQL/
datadir=C:/The Site/
skip-innodb

yes, tried winmysqladmin, no go, it just adds to the error log

Try:
Server=C:/Program Files/MySQL/bin/mysqld-nt.exe

nope, that didn't do it

Man, you reallly suck at this.

Whats in the error log?

 

[NuclearFusi0n]

Originally posted by: NuclearFusi0n
error log shows:

021122 3:11:13 MySql: Table 'mysql.host' doesn't exist

 

[n0cmonkey]

Originally posted by: NuclearFusi0n

Originally posted by: NuclearFusi0n
error log shows:

021122 3:11:13 MySql: Table 'mysql.host' doesn't exist

It looks pretty self explanatory to me. There are a couple of possibilities really.

 

[Cerebus451]

Originally posted by: NuclearFusi0n
error log shows:

021122 3:11:13 MySql: Table 'mysql.host' doesn't exist

In your data directory (c:/The Site) you should have a mysql subdirectory and in there should be files, among which would be host.frm, host.MYD and host.MYI. Those represent the table host in the database mysql, which is what it is complaining about missing.

 

[n0cmonkey]

Originally posted by: Cerebus451

Originally posted by: NuclearFusi0n
error log shows:

021122 3:11:13 MySql: Table 'mysql.host' doesn't exist

In your data directory (c:/The Site) you should have a mysql subdirectory and in there should be files, among which would be host.frm, host.MYD and host.MYI. Those represent the table host in the database mysql, which is what it is complaining about missing.

You deserve a cookie!

 

[NuclearFusi0n]

i copied /data/ to my site and changed the variable datadir to point to it

Many thanks!

btw should i use mysqld or mysqld-nt (on windows xp)

 

[Cerebus451]

Originally posted by: NuclearFusi0n
i copied /data/ to my site and changed the variable datadir to point to it

Many thanks!

btw should i use mysqld or mysqld-nt (on windows xp)

I use mysqld-nt, but I am also running under Windows 2000. I would probably run the NT server under XP given the choice.