Toolpack migration Debian4 2-3
From TBwiki
(Difference between revisions)
(→Configure ODBC driver manager) |
(add mysql connection through host name) |
||
| Line 8: | Line 8: | ||
Connect to MySQL and create a new user tbdb with all privilege. | Connect to MySQL and create a new user tbdb with all privilege. | ||
| + | If you are unable to connect, use an IP Address instead of the ''[HostName]''. | ||
| − | mysql -u root | + | mysql -u root -h '[HostName]' |
CREATE USER 'tbdb'@'%' IDENTIFIED BY '[DatabasePassword]'; | CREATE USER 'tbdb'@'%' IDENTIFIED BY '[DatabasePassword]'; | ||
GRANT ALL privileges ON *.* TO 'tbdb'@'%' IDENTIFIED BY '[DatabasePassword]'; | GRANT ALL privileges ON *.* TO 'tbdb'@'%' IDENTIFIED BY '[DatabasePassword]'; | ||
| Line 15: | Line 16: | ||
Example | Example | ||
| − | mysql -u root | + | mysql -u root -h debian64-01 |
CREATE USER 'tbdb'@'%' IDENTIFIED BY 'tbdbpw'; | CREATE USER 'tbdb'@'%' IDENTIFIED BY 'tbdbpw'; | ||
GRANT ALL privileges ON *.* TO 'tbdb'@'%' IDENTIFIED BY 'tbdbpw'; | GRANT ALL privileges ON *.* TO 'tbdb'@'%' IDENTIFIED BY 'tbdbpw'; | ||
Revision as of 08:46, 29 May 2009
This page shows the Toolpack 2-4 migration guide for Debian 4.
Contents |
Toolpack Migration Steps
Create new database user
Connect to MySQL and create a new user tbdb with all privilege. If you are unable to connect, use an IP Address instead of the [HostName].
mysql -u root -h '[HostName]' CREATE USER 'tbdb'@'%' IDENTIFIED BY '[DatabasePassword]'; GRANT ALL privileges ON *.* TO 'tbdb'@'%' IDENTIFIED BY '[DatabasePassword]'; exit
Example
mysql -u root -h debian64-01 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
Restart MySQL service
/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.
