Open Software Solutions

Show status information on a table. Note, if the database was started with --safe-show-database or --skip-show-database some of these commands may not work. Note the "\G" option may provide a nicer format. Show the create statement: mysql> show create table dupTest\G ... Read more..

You do not need to enter mysql for this , here is the exact sintax you must use : mysqldump -u [username] -p [database_name] > /path/to/file.sql  example mysqldump -u mario  -p marioDB > /tmp/marioDB.sql Read more..

Recovering / Changing Your MySQL Root Password Sometimes you may have to recover the MySQL root password because it was either forgotten or misplaced. The steps you need are: 1) Stop MySQL [root@bigboy tmp]# service mysqld stop Stopping MySQL:  [  OK  ] [root@bigboy tmp]# 2) Start MySQL in Safe mode with the mysqld_safe command and tell it not to read the grant tables with all the MySQL database passwords. [root@bigboy tmp]# mysqld_safe --skip-grant-tables --skip-networking & [1] 13007 [root@bigboy tmp]# Starting mysqld daemon with databases from /var/lib/mysql [root@bigboy tmp]# Note: In Fedora ... Read more..

Installation: configured for encryption, C API, and user defined functions. ./configure --with-openssl --enable-thread-safe-client --with-mysqld-ldflags=-rdynamic The --with-openssl is very helpful for creating your own password file. Also, if doing C API, having thread safe calls "could" come in handly...it's what I use. See (TIP 27) for user defined functions. Complete ... Read more..

Function CONCAT allows the SELECT statements to act like printf commands by ataching text results to query results and so on Example : Generate a list of links in HTML from a table 'mylinks' with the columns 'urls' (http://www.ossmall.info) with 'title' (Open Software Solutions) The output will look like this : <a href="http://www.ossmall.info">Open Software Solutions</a><br /> To do this you must use a select statement like: SELECT CONCAT('<a href="', urls, '">', title, '</a><br />') FROM mylinks; Read more..

Log in MySql To create a database called 'yourdatabase' use the following SQL command: create database yourdatabase; Read more..

We will  add a column called email to the mycontacts table created in Create a basic MySQL table with a datatype of VARCHAR(90) To do this use the following SQL statements: 1.  this statement will add the column at the bottom of the table  ALTER TABLE mycontacts ADD email VARCHAR(90); 2.  this statement will add the column after a specific column ( such as name ) ALTER TABLE mycontacts ADD email VARCHAR(90) AFTER name; 3. this statement will add the column at the begining of ... Read more..

This is how to create a user youruser with password YourPassword  and grant them full access to the  database named yourdatabase, connect to the database with mysql and issue the command: grant all on yourdatabase.* to user@localhost identified by 'YourPassword'; Read more..

To change the MySQL root password to DifferentPass , use: mysqladmin -u root password DifferentPass Keep in mind , root is a powerfull user in mysql , use Hard Passwords ! Read more..

Monitor port 3306: tcpdump -i eth0 -nN -vvv -xX -s 1500 port 3306 and host not 192.168.1.102 The -s is length of each packet. This monitors all traffic on port 3306 excluding the good client 192.168.1.102. The out will be in the following format: [root@third-fl-71 root]# tcpdump -i eth0 -nN -vvv -xX -s 1500 port ... Read more..