What is parse error ?

edhan · 09-16-2003, 06:39 PM

Quote:

Originally posted by daveo
I'm not sure what you trying to mention, but do you mean to run phpmyadmin as mysql@localhost?

Or do you mean from a terminal login? If that's the case just do:
# mysql -u mysql -p and typ the passwd from the mysql user

Yes. I meant terminal login. Tried it and it works. Now I wonder if the cause is due to the domain name as I have been trying it under localhost to do the posting. Does it has any differences between local and domain name?

Btw, do you know how I can set the MySQL to run during boot-up ?

Regards
Edward Han

daveo · 09-17-2003, 02:10 AM

Quote:

Originally posted by edhan
Yes. I meant terminal login. Tried it and it works. Now I wonder if the cause is due to the domain name as I have been trying it under localhost to do the posting. Does it has any differences between local and domain name?

Btw, do you know how I can set the MySQL to run during boot-up ?

Regards
Edward Han

* Make sure with phpmyadmin that mysql accept connections from a localhost, so if you define 127.0.0.1 in the php files, then a entry should exists in the privileges part like:

mysql localhost Yes SELECT, INSERT, UPDATE, etc, etc

* You might be able to add mysql to one of your runlevels with the tool chkconfig, example:

chkconfig --level 345 testservices on

Which will start the testservices at runlevel 345 Make sure to read man chkconfig first ...

Hope this helps,

edhan · 09-17-2003, 06:26 AM

Quote:

Originally posted by daveo
* Make sure with phpmyadmin that mysql accept connections from a localhost, so if you define 127.0.0.1 in the php files, then a entry should exists in the privileges part like:

mysql localhost Yes SELECT, INSERT, UPDATE, etc, etc

* You might be able to add mysql to one of your runlevels with the tool chkconfig, example:

chkconfig --level 345 testservices on

Which will start the testservices at runlevel 345 Make sure to read man chkconfig first ...

Hope this helps,

Hi Dave

Finally everything works PERFECT! I have added the command for the apache and mysql in the rc.local so that it will start automatically when the system boots up. I am still unsure how I can add the username mysql instead of root to run the mysql.
Do you have any suggestion?

Thank you for all your help and your patience! Do have a nice day!

Regards
Edward Han

daveo · 09-17-2003, 06:33 AM

Quote:

Originally posted by edhan
Hi Dave

Finally everything works PERFECT! I have added the command for the apache and mysql in the rc.local so that it will start automatically when the system boots up. I am still unsure how I can add the username mysql instead of root to run the mysql.
Do you have any suggestion?

Thank you for all your help and your patience! Do have a nice day!

Regards
Edward Han

Hi Edward!

Yah well anytime ...

* Try the following in your rc.local to start mysql:
mysqld_safe --user mysql (NOTE: make sure that the user exists on your system and has the proper rights on your database files mostly located at /var/mysql or something.)

* If you got any questions in the future drop them in my forum, because you solved this problem and i'm "unwatching" this topic.

Which you all the best and have a nice day to!

edhan · 09-17-2003, 06:49 AM

Quote:

Originally posted by daveo
Hi Edward!

Yah well anytime ...

* Try the following in your rc.local to start mysql:
mysqld_safe --user mysql (NOTE: make sure that the user exists on your system and has the proper rights on your database files mostly located at /var/mysql or something.)

* If you got any questions in the future drop them in my forum, because you solved this problem and i'm "unwatching" this topic.

Which you all the best and have a nice day to!

BTW, my database is now READ Only and I can't do any amendment. I have chmod & chgrp as well as chown to mysql. It still can't work with the rights set as 755. Any idea?

Thanks for the tip. I will check to see if it works.

Anyway, in future I will be dropping by your forum. See you.

Regards
Edward Han