Dyntex.net Support Centre: MySQL Reference Manual p.98

<< previous page -- table of contents -- next page >>

Chapter_1

Chapter_2

Chapter_3

Chapter_4

Chapter_5

Return to Table of Contents

Table of Contents
1. General Information
2. MySQL Installation
3. Tutorial Introduction
4. Database Administration
5. MySQL Optimisation
6. MySQL Language Reference
7. MySQL Table Types
8. MySQL APIs
9. Extending MySQL

98 MySQL Technical Reference for Version 4.0.3 shell> mysqladmin -h 'your-host-name' variables If you get Errcode 13, which means Permission denied, when starting mysqld this means that you didn't have the right to read/create les in the MySQL database or log directory. In this case you should either start mysqld as the root user or change the permissions for the involved les and directories so that you have the right to use them. If safe_mysqld starts the server but you can't connect to it, you should make sure you have an entry in `/etc/hosts' that looks like this: 127.0.0.1 localhost This problem occurs only on systems that don't have a working thread library and for which MySQL must be congured to use MIT-pthreads. If you can't get mysqld to start you can try to make a trace le to nd the problem. See Section E.1.2 [Making trace les], page 759. If you are using InnoDB tables, refer to the InnoDB-specic startup options. See Sec- tion 7.5.2 [InnoDB start], page 507. If you are using BDB (Berkeley DB) tables, you should familiarise yourself with the dierent BDB specic startup options. See Section 7.6.3 [BDB start], page 534. 2.4.3 Starting and Stopping MySQL Automatically The mysql.server and safe_mysqld scripts can be used to start the server automatically at system startup time. mysql.server can also be used to stop the server. The mysql.server script can be used to start or stop the server by invoking it with start or stop arguments: shell> mysql.server start shell> mysql.server stop mysql.server can be found in the `share/mysql' directory under the MySQL installation directory or in the `support-files' directory of the MySQL source tree. Before mysql.server starts the server, it changes the directory to the MySQL installation directory, then invokes safe_mysqld. You might need to edit mysql.server if you have a binary distribution that you've installed in a non-standard location. Modify it to cd into the proper directory before it runs safe_mysqld. If you want the server to run as some specic user, add an appropriate user line to the `/etc/my.cnf' le, as shown later in this section. mysql.server stop brings down the server by sending a signal to it. You can take down the server manually by executing mysqladmin shutdown. You might want to add these start and stop commands to the appropriate places in your `/etc/rc*' les when you start using MySQL for production applications. Note that if you modify mysql.server, and then upgrade MySQL sometime, your modied version will be overwritten, so you should make a copy of your edited version that you can reinstall. If your system uses `/etc/rc.local' to start external scripts, you should append the fol- lowing to it:

MySQL Reference Manual

Our Partners

SpiritHost - web hosting for spiritual and education sites
SpiritHit.com - Religious and Spiritual Portal

Return to Table of Contents	Back to top

Web Hosting: Manuals & FAQ's

1. Unix-Based Web Hosting
2. Unix Dedicated Servers
3. Windows Dedicated Servers
4. CuteFTP User’s Guide
5. CuteHTML User’s Guide
6. WS_FTP Pro User's Guide
7. Miva Order User's Guide
8. Miva Merchant User's Guide