Mini Servers: MySQL 4.1.22 Service: Difference between revisions

{{Uc nav mini servers}}

[[Image:Uc_mini_14.gif|MySQL 4.1.22|right]]'''Mini Server 12 MySQL 4.1.22-community-nt Core'''

'''Original:'''  

!my.cnf located in folder: C:\mini_server_14\bin

|

# Uncomment the following rows if you move the MySQL distribution to another

# location

|}

'''Change to:'''

!my.cnf located in folder: C:\mini_server_14\bin

|

# Uncomment the following rows if you move the MySQL distribution to another

# location

|}

The second line starts the service notice it uses the unique name defined in the first line.  

!install.bat located in folder: C:\mini_server_14

|

C:\mini_server_14\bin\mysqld-opt.exe --install mini_server_14 --defaults-file=C:/mini_server_14/bin/my.cnf

net start mini_server_14

|}

The uninstall batch file first stops the “MySQL” service and then proceeds to uninstall it. Note the use of the service name '''mini_server_14'''.

!uninstall.bat located in folder: C:\mini_server_14

|

net stop mini_server_14

bin\mysqld-opt.exe --remove mini_server_14

|}

This batch file provides a convenient way to start a command window at the right location to run MySQL clients. It displays a quick start guide for reference.

!console.bat located in folder: C:\mini_server_14

|

cd bin

start cmd.exe /k type quick_start_guide.txt

|}

== Command Line ==

* '''net stop mini_server_14'''

=== Download ===

'''''Note'':''' Check out the mini server's [[Mini Servers: Support and download|support and download page]] detailing how to obtain full binaries for MySQL.

# Install the server by double clicking on '''install.bat'''

# Run console.bat this opens a command window.

Result similar to this confirms server is running:

Uptime: 72  Threads: 1  Questions: 1  Slow queries: 0  Opens: 12

Flush tables: 1  Open tables: 3  Queries per second avg: 0.014

'''''[[#top | Top]]'''''

At the top of the file you will find there are two port lines these need changing locate this section:

# This will be passed to all mysql clients

[client]

port=3314

#socket=MySQL

and change as shown:

# This will be passed to all mysql clients

[client]

port=3307

#socket=MySQL

'''''[[#top | Top]]'''''

'''Server upgrade:''' If you upgrade the MySQL  server it's default is to have no password set, in this situation use the following to set a password:  

'''''Note'':''' ''password'' before NEWPASSWORD is a command.  

'''Mini Server downloaded:''' Mini Server 4a has both user name and password set to root. To change an existing password use the following:

   

For example to change the root password to fred123

To re-log in use the new password for example:

Uptime: 571  Threads: 1  Questions: 6  Slow queries: 0  Opens: 13  Flush tables: 1  Open tables: 4  Queries per second a

vg: 0.011

==== Change password for other users ====

To change a normal user's password you follow a similar process for example user mike, old password fred123 and new password power26:

'''''[[#top | Top]]'''''

'''Log into Mini Server 14'''

The following example logs into and then out of the server. At the mysql prompt I have typed '''quit''' this terminate the program logs out of the server.   

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 2 to server version: 4.1.22-community-nt

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

Bye

'''Quick Example:'''

'''''Commands used'':'''

quit

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 5 to server version: 4.1.22-community-nt

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

+---------------------+--------------+

| VERSION()          | CURRENT_DATE |

1 row in set (0.01 sec)

+----------+

| Database |

1 row in set (0.00 sec)

Bye

    

'''''[[#top | Top]]'''''

Use the following method to update or change password for user root

For example change the root user password to fred123  

Database changed

Query OK, 0 rows affected (0.00 sec)

Rows matched: 2  Changed: 0  Warnings: 0

Query OK, 0 rows affected (1.03 sec)

Bye

--- Test new password ----------

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 11

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

Bye

'''''[[#top | Top]]'''''

==== Change Root User name ====

The root user does not need to be named 'root'. Most attackers will obviously try to compromise the 'root' user account and will be stopped if there is no 'root' user. To change the name of the root user account, use the following commands:

'''''[[#top | Top]]'''''

In addition, the root account can be restricted to login from localhost with the following commands:

'''''Note'':''' Like Uniform Server 3.5-Apollo the mini server already restricts access to localhost only.   

'''''Note'':''' Shown as an example it does not exist on the mini server.

'''''Note'':''' The mini server does not include an anonymous account.