Group items tagged

sudo su

/etc/init.d/apparmor stop update-rc.d -f apparmor remove apt-get remove apparmor apparmor-utils

groupadd mysql useradd -r -g mysql mysql

Step 3: Edit the my.cnf file

Search for the following line:[mysqld] Make sure line skip-networking is commented (or remove line) and add following line:bind-address=YOUR-SERVER-IPSo if your IP is 69.195.199.51 the entire block should look like this:[mysqld] port = 3306 socket = /var/lib/mysql/mysql.sock skip-locking key_buffer_size = 16K max_allowed_packet = 1M table_open_cache = 4 sort_buffer_size = 64K read_buffer_size = 256K read_rnd_buffer_size = 256K net_buffer_length = 2K thread_stack = 128K bind-address = 69.195.199.51 # skip-networking

Step 4: Save & RestartSave your edits by clicking on the Save button and restart MySQL by clicking RestartStep 5: Grant access to remote IP addressGo to the terminal in the control panel and log in (or connect via SSH) and connect to your MySQL database.$ mysql -u root -p mysqlGrant access to a new database If you want to add a new database called foo for user bar and remote IP 69.195.199.100 then you need to type the following commands at mysql> prompt:mysql> CREATE DATABASE foo; mysql> GRANT ALL ON foo.* TO bar@'69.195.199.100' IDENTIFIED BY 'PASSWORD';How Do I Grant Access To An Existing Database? To grant access to an existng database called foo for user bar and remote IP 69.195.199.100 type the following command At mysql> prompt for existing database, enter:mysql> GRANT ALL ON foo.* TO bar@'69.195.199.100' IDENTIFIED BY 'PASSWORD';

MySQL supports replication from one major version to the next higher major version. For example, you can replicate from a master running MySQL 4.1 to a slave running MySQL 5.0, from a master running MySQL 5.0 to a slave running MySQL 5.1, and so on.

Important It is strongly recommended to use the most recent release available within a given MySQL major version because replication (and other) capabilities are continually being improved. It is also recommended to upgrade masters and slaves that use early releases of a major version of MySQL to GA (production) releases when the latter become available for that major version.

Installing and Configuring Apache

apt-get install apache2

etc/init.d/apache2 start|stop|restart|reload|force-reload apacheclt start|stop|restart|...

For example, suppose you want to add support for MySQL. (As of OWB 11g R2, MySQL is not on the list of supported by default platforms.) All you need to do, though, is download the MySQL JDBC driver to put it into the OWB_HOME/owb/lib/ext directory, and add the platform definition for MySQL via a Tcl script that you can run from the OMB Plus console. The contents of such a script is beyond the scope of this article. However, if you want to look at one, check out this post by David Allan, where you’ll find a detailed example of how you can add support for MySQL to Oracle Warehouse Builder 11g Release 2. Also, there is a whitepaper on OTN called the "OWB Platform and Application Adapter Extensibility Cookbook", which goes into more depth than David’s post.

mysqldump -h localhost -u [MySQL user, e.g. root] -p[database password] -c --add-drop-table --add-locks --all --quick --lock-tables [name of the database] > sqldump.sql

Extract the Database

Queries time

InfoBright was fully 1 CPU bound during all queries.