Toolpack migration Debian4 2-3 - Revision history

Cbilodeau: add mysql configuration file modification

2009-11-03T18:54:56Z

add mysql configuration file modification

Cbilodeau: add disable 2.2 system

2009-06-05T12:51:07Z

add disable 2.2 system

Cbilodeau: add mysql connection through host name

2009-05-29T13:46:58Z

add mysql connection through host name

Cbilodeau: /* Configure ODBC driver manager */

2009-05-19T20:15:21Z

Configure ODBC driver manager

Cbilodeau: Toolpack migration debian4 2-3 moved to Toolpack migration Debian4 2-3: move to correct cases

2009-05-19T19:33:25Z

Toolpack migration debian4 2-3 moved to Toolpack migration Debian4 2-3: move to correct cases

10.0.0.157: Creation

2009-05-19T18:45:29Z

Creation

New page

This page shows the Toolpack 2-4 migration guide for Debian 4.

== Toolpack Migration Steps ==

=== Create new database user ===

Connect to MySQL and create a new user tbdb with all privilege.

mysql -u root
CREATE USER 'tbdb'@'%' IDENTIFIED BY '[DatabasePassword]';
GRANT ALL privileges ON *.* TO 'tbdb'@'%' IDENTIFIED BY '[DatabasePassword]';
exit

Example
mysql -u root
CREATE USER 'tbdb'@'%' IDENTIFIED BY 'tbdbpw';
GRANT ALL privileges ON *.* TO 'tbdb'@'%' IDENTIFIED BY 'tbdbpw';
exit

=== Install ODBC MySQL connector ===

apt-get install libmyodbc

=== Configure ODBC driver manager ===

odbcinst -i -f /usr/share/libmyodbc/odbcinst.ini -d

== Toolpack System installation ==

Now that the prerequisite are installed, we can go back to the migration guide [[Toolpack_migration_2-3|Toolpack migration 2-3]].

← Older revision		Revision as of 18:54, 3 November 2009
Line 30:		Line 30:

	odbcinst -i -f /usr/share/libmyodbc/odbcinst.ini -d		odbcinst -i -f /usr/share/libmyodbc/odbcinst.ini -d
		+
		+
		+	=== Modify MySQL configuration ===
		+	Configure mysql to support database replication (Will not interfere if your system do not use it).
		+	vi /etc/mysql/my.cnf
		+
		+	6.Add 2 new variable in the mysql config file
		+
		+	Comment out the bind-address line (put a '#' in front of the line)
		+	Example:
		+	# bind-address = 127.0.0.1
		+
		+	Add log-bin and server-id. The value of server-id needs to be unique on each host( do not use 0 ).
		+
		+	Make sure it is in the [mysqld] section
		+
		+	log-bin
		+	server-id=''[UniqueId]''
		+
		+	Example:
		+	# The following can be used as easy to replay backup logs or for replication.
		+	server-id = 1
		+	log_bin = /var/log/mysql/mysql-bin.log
		+
		+	Restart MySQL service
		+	service mysql restart

@@ Line 35: / Line 35: @@
    /etc/init.d/mysql restart
 == Toolpack System installation ==
 Now that the prerequisite are installed, we can go back to the migration guide [[Toolpack_migration_2-3|Toolpack migration 2-3]].

@@ Line 8: / Line 8: @@
 Connect to MySQL and create a new user tbdb with all privilege.
-   mysql -u root
+   mysql -u root -h '[HostName]'
    CREATE USER 'tbdb'@'%' IDENTIFIED BY '[DatabasePassword]';
    GRANT ALL privileges ON *.* TO 'tbdb'@'%' IDENTIFIED BY '[DatabasePassword]';
@@ Line 15: / Line 16: @@
 Example
-   mysql -u root
+   mysql -u root -h debian64-01
    CREATE USER 'tbdb'@'%' IDENTIFIED BY 'tbdbpw';
    GRANT ALL privileges ON *.* TO 'tbdb'@'%' IDENTIFIED BY 'tbdbpw';