Skip to content

Mysql

November 28, 2007

To start mysql
# /usr/bin/mysqld_safe
win: mysqld –console


To stop mysql
# mysqladmin -u root -ptemp shutdown

To view the startup variables
# mysqladmin -u root -ptemp variables

vi /etc/my.cnf
[mysqld]
set-variable=lower_case_table_names=1
basedir=/
datadir=/var/lib/mysql
user=mysql
port=3306
pid-file=/var/lib/mysql/csflx047.pid
skip-external-locking

Starting the service
service mysql start/stop

Mysql Java Connection string
jdbc:mysql://host:port/db&user=your_user&password=your_password

Advertisements
No comments yet

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: