# Database Setup for MySQL

This topic provides the steps that need to be performed by the individual responsible for the administration of MySQL to setup the database for PDFKeeper.

Note, this topic only provides instructions for performing the setup on the same computer as MySQL since remote administrative access is disabled by default. This requires that PDFKeeper be installed on the same computer as MySQL to perform the database setup. As an alternative, you can copy MySqlDatabaseSetup.sql from %LOCALAPPDATA%\Programs\PDFKeeper to the computer hosting MySQL Server.

Perform the following steps to setup the database. Note, these instructions assume that the MySQL Server version is 8.4 and the root account is being used for MySQL administration.

1. Open a Command Prompt.

2. Execute "C:\Program Files\MySQL\MySQL Server 8.4\bin\mysql.exe" -u root -p < “<ABSOLUTE_PATH>\MySqlDatabaseSetup.sql”

- Replace <ABSOLUTE_PATH> with %LOCALAPPDATA%\Programs\PDFKeeper if PDFKeeper is installed on the same computer as MySQL Server or the folder path where MySqlDatabaseSetup.sql was copied to.

3. Enter the password when prompted.