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!)

About this user

http://installingcats.com

12 total

On This Page:

  1. 1 Export mysql table into csv
  2. 2 change mysql user password
  3. 3 Test php mysql pdo_mysql
  4. 4 import data into mysql
  5. 5 add mysql symbolic link to OS X MacPorts installed mysql
  1. 6 mysql on OS X
  2. 7 /tmp/mysql.sock file not found
  3. 8 mysql add user
  4. 9 change mysql root password
  5. 10 Show foreign keys for table in mysql

Export mysql table into csv

to mysql by deckard on Apr 06, 2008
Use /tmp, as mySql doesn't have write privileges everywhere.

select * into outfile '/tmp/outfile.txt' fields terminated by ',' from my_table_name;

change mysql user password

to mysql admin by deckard on Mar 26, 2008
From terminal (square brackets denote your input, do not actually include the brackets):

mysqladmin -u [user] -h localhost -p password '[new_password]'

Test php mysql pdo_mysql

to php mysql administration by deckard on Mar 14, 2008 2 Comments
// description of your code here

<?php $link = mysql_connect('localhost','mydbuser','mydbpassword');
if (!$link) {
        die('Could not connect to MySQL: ' . mysql_error());
} echo 'mySql Connection OK';
mysql_close($link);

$dbh = new PDO('mysql:host=localhost;dbname=test','mydbuser','mydbpassword');
if ($dbh) {
        echo 'mysql_pdo CONNECTION OK';
}
else {echo 'mysql_pdo ERROR';}
?>

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

add mysql symbolic link to OS X MacPorts installed mysql

to mysql mac administration by deckard on Jun 21, 2007
instead of having to type out mysql5 each time I want to run mysql, make a symbolic link to mysql5

ln -s ../lib/mysql5/bin/mysql /opt/local/bin/mysql

mysql on OS X

to mysql mac administration by deckard on Jun 21, 2007
mysql installed via ports by default resides in

/opt/local/share/mysql5/mysql


from this location you can start/stop mysql with the following

./mysql.server stop
./mysql.server start


to have a my.cnf file to edit

sudo cp my-small.cnf my.cnf

/tmp/mysql.sock file not found

to mysql rails debugging by deckard on Jun 11, 2007
first finds where your .sock file is

second sets a symbolic link to the sock so Rails' default location for the sock is cool

mysql_config --socket

sudo ln -s  /var/run/mysqld/mysqld.sock /tmp/mysql.sock

mysql add user

to mysql administration by deckard on Jun 08, 2007
// description of your code here

mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost'
    ->     IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

change mysql root password

to mysql administration by deckard on Jun 08, 2007
// description of your code here

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

Show foreign keys for table in mysql

to mysql constraints show by deckard on Apr 14, 2007
// description of your code here

show create table <table_name>
12 total

On This Page:

  1. 1 Export mysql table into csv
  2. 2 change mysql user password
  3. 3 Test php mysql pdo_mysql
  4. 4 import data into mysql
  5. 5 add mysql symbolic link to OS X MacPorts installed mysql
  1. 6 mysql on OS X
  2. 7 /tmp/mysql.sock file not found
  3. 8 mysql add user
  4. 9 change mysql root password
  5. 10 Show foreign keys for table in mysql