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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Change mysql variables
- Thread starter blinx
- Start date
sleipnir214
Programmer
What version of MySQL are you running? Want the best answers? Ask the best questions: TANSTAAFL!
- Thread starter
- #3
sleipnir214
Programmer
The best way is to modify my.cnf. You're going to have to login to the server as a user with sufficient rights, edit my.cnf (whereever it is on the server), and restart MySQL.
Unfortunately, I can't advise you closer than that. There are just too many possible variations on how to do it. Want the best answers? Ask the best questions: TANSTAAFL!
Unfortunately, I can't advise you closer than that. There are just too many possible variations on how to do it. Want the best answers? Ask the best questions: TANSTAAFL!
- Thread starter
- #5
I know this sounds extremely rudimentary but how do i start and stop mysql.
i guess to start it i type /path/mysqld or should i be using safe_mysqld ? and how do i stop it because if i try that at the moment it just says cant do it cos the serevr is already running. ?
cheers lee
i guess to start it i type /path/mysqld or should i be using safe_mysqld ? and how do i stop it because if i try that at the moment it just says cant do it cos the serevr is already running. ?
cheers lee
sleipnir214
Programmer
Unfortunately, I don't know enough about your platform or how MySQL was installed on it.
Want the best answers? Ask the best questions: TANSTAAFL!
Want the best answers? Ask the best questions: TANSTAAFL!
||>/etc/rc.d/init.d/mysqld start
||>/etc/rc.d/init.d/mysqld stop
This should work on Cobalt Raq550.
Want more
Bye
Qatqat The reason why my girlfriend can read my thoughts is because mine are properly written! (G.Lepore)
||>/etc/rc.d/init.d/mysqld stop
This should work on Cobalt Raq550.
Want more
Bye
Qatqat The reason why my girlfriend can read my thoughts is because mine are properly written! (G.Lepore)
- Thread starter
- #8
Hi
I looked at the mail list link and the person there had the same trouble as me; mysqld appears to be in /usr/sbin/ on the raq 550 and having said that if i try /usr/sbin/mysqld status as that post suggests i get "too many parameters" and told to look at the mysqld options by typing /usr/sbi/mysqld --help , if i do this there is no mention of the options -- status, start or stop.
I'm amazed how difficult it is to find out how to start/stop the mysql daemon.
I looked at the mail list link and the person there had the same trouble as me; mysqld appears to be in /usr/sbin/ on the raq 550 and having said that if i try /usr/sbin/mysqld status as that post suggests i get "too many parameters" and told to look at the mysqld options by typing /usr/sbi/mysqld --help , if i do this there is no mention of the options -- status, start or stop.
I'm amazed how difficult it is to find out how to start/stop the mysql daemon.
- Status