Never been to CodeSnippets before?

Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world (or not, you can keep them private!)

Showing 11 - 20 of 70 total

On This Page:

  1. 1 import data into mysql
  2. 2 mysql jdbc access conf
  3. 3 Manually Starting & Stopping MySQL in Leopard
  4. 4 MySQL 5 macports setup
  5. 5 Setup LAMP on Ubuntu with MyODBC support.
  1. 6 Give remote access to mysql
  2. 7 Remove Existing MySQL Installations
  3. 8 Change Root user password
  4. 9 MySQL add user
  5. 10 Macports MySQL 5 startup on launch

import data into mysql

to mysql by deckard on Feb 20, 2008
Things to note:
Mysql may not have access to the directory you've put the datafile. Use /tmp to overcome this problem.
Datafile name must be the same as the mysql table you're importing to.

mysqlimport -u username -p --columns=column_1,column_2 --fields-terminated-by=',' databasename /tmp/data_file_same_as_mysql_table_name

mysql jdbc access conf

to mysql jdbc conf by xico on Jan 30, 2008 

url : jdbc:mysql://host_name:port/dbname

driver class name : com.mysql.jdbc.Driver

Manually Starting & Stopping MySQL in Leopard

to mysql osx start leopard stop mysql5 source built by minofare on Jan 22, 2008
This is for software built from source according to:
http://hivelogic.com/articles/installing-mysql-on-mac-os-x/

Start MySQL
sudo launchctl unload -w /Library/LaunchDaemons/com.mysql.mysqld.plist


Stop MySQL
sudo launchctl load -w /Library/LaunchDaemons/com.mysql.mysqld.plist


MySQL 5 macports setup

to mysql setup start stop mysql5 socket by minofare on Jan 16, 2008 2 Comments
You have to symlink mysql to the location on osx

first find out where mysql has put the socket:
mysql_config5 --socket

Next symlink /tmp/mysql.sock to the right location of the socket
sudo ln -s path-of-mysql.sock-from-above /tmp/mysql.sock


Start MySQL
sudo /opt/local/share/mysql5/mysql/mysql.server start

or
/opt/local/bin/mysqld_safe5


Stop MySQL
sudo /opt/local/share/mysql5/mysql/mysql.server stop

Setup LAMP on Ubuntu with MyODBC support.

to apache php mysql odbc myodbc by minofare on Jan 07, 2008
Go to terminal:

sudo apt-get install apache2 mysql-server php5 php5-odbc libapache2-mod-php5 php5-xsl php5-gd php-pear libapache2-mod-auth-mysql php5-mysql libmyodbc


Now hand edit (or create, if it does not exist already) /etc/odbc.ini

Here's an example odbc.ini:

[ODBC Data Sources]
odbcname     = MyODBC 3.51 Driver DSN

[odbcname]
Driver       = /usr/lib/odbc/libmyodbc.so
Description  = MyODBC 3.51 Driver DSN
SERVER       = my.database.server.com
PORT         =
USER         = USER
Password     = XXXXXX
Database     = DBNAME
OPTION       = 3
SOCKET       =

[Default]
Driver       = /usr/local/lib/libmyodbc3.so
Description  = MyODBC 3.51 Driver DSN
SERVER       = localhost
PORT         =
USER         = root
Password     =
Database     = test
OPTION       = 3
SOCKET       =


Remember to start and stop mysql and apache:

sudo /etc/init.d/mysql start
sudo /etc/init.d/apache2 start

sudo /etc/init.d/mysql stop
sudo /etc/init.d/apache2 stop
sudo /etc/init.d/mysql restart
sudo /etc/init.d/apache2 restart

Give remote access to mysql

to mysql remote access by minofare on Jan 07, 2008 
mysql -u root -p (your password)


then write the following

GRANT ALL PRIVILEGES ON *.* TO user@'%' IDENTIFIED BY 'PASSWORD';


then

FLUSH PRIVILEGES;

Remove Existing MySQL Installations

to mysql osx installer remove symlink uninstall by minofare on Jan 03, 2008
If you already have MySQL installed and used the package installer from MySQL to install it, you need to remove a single file (actually a symlink) to disable it:

sudo rm /usr/local/mysql


If you also installed the StartupItem package, you’ll want to remove it as well. Keep in mind that if you ever want to auto-start the old version of MySQL later on, you’ll need to re-download the package installer and reinstall the StartupItem.

sudo rm -rf /Library/StartupItems/MySQLCOM/

Change Root user password

to mysql password root change by minofare on Jan 03, 2008 


mysql -h localhost -u root
mysql> USE mysql;
mysql> UPDATE user SET Password=PASSWORD('root-pwd') WHERE user='root';
mysql> FLUSH PRIVILEGES;
mysql> EXIT

MySQL add user

to mysql user add by minofare on Jan 03, 2008 
mysql> GRANT ALL PRIVILEGES ON *.* TO 'user'@'localhost'
    ->     IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

Macports MySQL 5 startup on launch

to mysql macports startup mysql5 by minofare on Jan 03, 2008
A startup item has been generated that will aid in starting mysql5 with launchd. It is disabled by default. Execute the following command to start it, and to cause it to launch at startup:
sudo launchctl load -w /Library/LaunchDaemons/org.macports.mysql5.plist


Showing 11 - 20 of 70 total

On This Page:

  1. 1 import data into mysql
  2. 2 mysql jdbc access conf
  3. 3 Manually Starting & Stopping MySQL in Leopard
  4. 4 MySQL 5 macports setup
  5. 5 Setup LAMP on Ubuntu with MyODBC support.
  1. 6 Give remote access to mysql
  2. 7 Remove Existing MySQL Installations
  3. 8 Change Root user password
  4. 9 MySQL add user
  5. 10 Macports MySQL 5 startup on launch