mysql-configure.txt

开源MARC数据处理

Configuring MySQL database without phpmyadmin:

Install a web server such as Apache that can execute cgi applications. If you install Apache, get familiar with starting and stopping your Apache Web Server. If you are running Windows 95 or Windows 98 there will be "Start Apache" and "Stop Apache" icons that will help you start and stop your web server. You may want to consider adding the "Start Apache" icon to your startup folder. If you are running NT you can add Apache as a service which will be running, even if you are logged off. If you are running Linux your Apache server should be packaged with your Linux installation and will start when you start Linux. 
Install the MySQL database from http://www.mysql.com/. Get familiar with starting and stopping your MySQL Server. See Starting MySQL on Windows 95 or Windows 98 for more information.

If you are running NT, setup MySQL as a service so it starts whenever the machine powers up. See Starting MySQL on Windows NT or Windows 2000 for more information on starting MySQL as a service.

If you are running Linux, MySQL should be packaged with your Linux installation and will start when you start Linux. 
Get familiar with logging into MySQL with your admin account within a DOS prompt window. You can use the following command sequence as a test. 

C:\>c:\mysql\bin\mysql -uadmin -p mysql

If this is your first install, a password is not necessary. You will
only type c:\mysql\bin\mysql and you're in. If you're asked for a passsword
then just press enter.

Enter password: *********
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8 to server version: 3.23.26-beta

Type 'help;' or '\h' for help. Type '\c' to clear the buffer

mysql> show databases;
+--------------+
| Database     |
+--------------+
| mysql        |
+--------------+
6 rows in set (0.00 sec)

mysql> exit
Bye

C:\>

Create a database named mydb. To do this, log into MySQL with your admin account and run the following SQL command. 
mysql> create database mydb;

To check to make sure the mydb database was created properly run the following command. 
mysql> show databases;
+--------------+
| Database     |
+--------------+
| mysql        |
| mydb		   |
+--------------+

Create an OpenBiblio database user. To do this login to MySQL under the admin userid and run the following SQL command, substituting obiblio_user and obiblio_password with the userid and password of your choice. 
mysql> grant all privileges on mydb.* to mydb_user@localhost
    -> identified by 'mydb_password' with grant option;

Verify your mydb database and user by logging into the new MySQL database under the new user. 
C:\mysql\bin\mysql -umydb_user -pmydb_password mydb

Then execute this

C:\mysql\bin\mysql -umydb_user -pmydb_password mydb < phpmylibrary.sql
Note: copy-paste phpmylibrary.sql file from PhpMyLibrary/polerio/sql/ directory

Edit your PhpMyLibrary/config/conf.php then encode the following parameters

$config['prefix'] = '';
$config['dbtype'] = 'mysql';
$config['dbhost'] = 'localhost';
$config['dbuname'] = 'mydb_user';
$config['dbpass'] = 'mydb_password';
$config['dbname'] = 'mydb';

(This is a modified version from openbiblio database instruction)