![]() ![]() innodb_log_group_home_dir=".\UniServerZ\core\mysql\data " Full path to innodb log group folderįorces the MySQL server to use a specific configuration file for example new_my.ini. innodb_data_home_dir=".\UniServerZ\core\mysql\data " Full path to innodb data home folder datadir=".\UniServerZ\core\mysql\data " Full path to data folder tmpdir=".\UniServerZ\tmp " Full path to temp folder defaults-file=".\UniServerZ\core\mysql\new_my.ini " Full path to MySQL configuration file \UniServerZ\core\mysql\bin\mysqld_z.exe -defaults-file=" " -tmpdir=" " -datadir=" " -innodb_data_home_dir=" " -innodb_log_group_home_dir=" " Internally UniController uses a command-line to start the MySQL server with the following format: UniController MySQL command-line parameter override. 0 eventsġ30706 11:55:36 C:\UniServer\core\mysql\bin\mysqld1.exe: Shutdown complete Version: '5.5.14' socket: '' port: 3306 MySQL Community Server (GPL)ġ30706 11:55:35 C:\UniServer\core\mysql\bin\mysqld1.exe: Normal shutdownġ30706 11:55:35 Event Scheduler: Purging the queue. Note: Depending on where you extracted UniServer, the path may differ.ġ30706 11:40:41 Plugin 'FEDERATED' is disabled.ġ30706 11:40:41 Plugin 'InnoDB' is enabled.ġ30706 11:40:43 Event Scheduler: Loaded 0 eventsġ30706 11:40:43 C:\UniServer\core\mysql\bin\mysqld1.exe: ready for connections. The path to the log file is: UniServerZ\core\mysql\data\ mysql.err If you are experiencing problems with the server, this should be your first port of call its content may shed light on a particular issue. This menu option provides a convenient short cut, allowing you to view the MySQL server log file. Location of the configuration file: UniServerZ\core\mysql\ my.ini MySQL error log The following sub-menu opens the MySQL configuration file in notepad, allowing you to directly edit the file: The Uniform Server's database restore allows for manual restore of a selected database.įor detailed information, see MySQL Database backup restore Edit Config file my.ini The Uniform Server's database backup allows for manual backup of a selected database.įor detailed information, see MySQL Database backup restore Database restore The same aspects for creating a restricted user (above) apply to editing restricted users.įor detailed information, see MySQL Edit Restricted User Database backup There are three methods for creating a restricted user: at a command prompt, with phpMyAdmin or through UniController.įor detailed information, see MySQL Create Restricted User Edit Restricted MySQL User ![]() There are three methods for creating or deleting a database: via command prompt, phpMyAdmin or UniController.įor detailed information, see MySQL Create Delete Database Create Restricted MySQL UserĪ restricted user has no root privileges and is constrained to a single database. Note: For detailed information, see MySQL - Restore password Create Delete Database In either situation the MySQL server is started or re-started with no grant tables and the password restored, after restoration the MySQL server is stopped. You can run restore password with or without the MySQL server running. Restoring the MySQL root password is fully automated just click the following sub-menu: Note 2: For detailed information, see MySQL - Change password Restore default password (root) Note 1: Clicking the cancel button no action is taken. The Set New MySQL Password menu opens (See image on right).Starting UniController provides the first opportunity to change the current root password, it is highly recommended that you set this password at the first opportunity.Īlternatively you can skip setting a new MySQL root password and run this menu option later using: The environment variable MYSQL_TCP_PORT is used by MySQL standard utilities. The Uniform Server Zero XI sets the port environment variable MYSQL_TCP_PORT and updates the user configuration file user_configuration.bat. ![]() Note 1: For new port to become effective you must restart the servers. The "Change MySQL port" menu allows you to specify the MySQL port (Standard port 3306). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |