These are some MySql commands (most run at the command line in linux) that I’ve been collecting since getting a few sites set up on linode. The “#” indicates that it is to be run from the unix shell. When you see “mysql>” the command is to be run from the MySQL command prompt after logging into MySQL.

MySQL Command to login (from unix shell) use -h only if needed.

# [mysql dir]/bin/mysql -h hostname -u root -p

MySQL Command to Create a database on the sql server.

mysql> create database [databasename];

MySQL Command to List all databases on the sql server.

mysql> show databases;

MySQL Command to Switch to a database.

mysql> use [db name];

MySQL Command to see all the tables in the db.

mysql> show tables;

MySQL Command to see database’s field formats.

mysql> describe [table name];

MySQL Command to delete a db.

mysql> drop database [database name];

MySQL Command to delete a table.

mysql> drop table [table name];

MySQL Command to Join tables on common columns.

mysql> select lookup.illustrationid, lookup.personid,person.birthday from lookup left join person on lookup.personid=person.personid=statement to join birthday in person table with primary illustration id;

MySQL Command to Create a new user. Login as root. Switch to the MySQL db. Make the user. Update privs.

# mysql -u root -p
mysql> use mysql;
mysql> INSERT INTO user (Host,User,Password) VALUES('%','username',PASSWORD('password')); 
mysql> flush privileges;

MySQL Command Change a users password from unix shell.

# [mysql dir]/bin/mysqladmin -u username -h hostname.blah.org -p password 'new-password'

MySQL Command to Change a users password from MySQL prompt. Login as root. Set the password. Update privs.

# mysql -u root -p
mysql> SET PASSWORD FOR 'user'@'hostname' = PASSWORD('passwordhere');
mysql> flush privileges;

MySQL Command to Recover a MySQL root password. Stop the MySQL server process. Start again with no grant tables. Login to MySQL as root. Set new password. Exit MySQL and restart MySQL server.

# /etc/init.d/mysql stop
# mysqld_safe --skip-grant-tables &
# mysql -u root
mysql> use mysql;
mysql> update user set password=PASSWORD("newrootpassword") where User='root';
mysql> flush privileges;
mysql> quit<br /> 
# /etc/init.d/mysql stop
# /etc/init.d/mysql start

MySQL Command to Set a root password if there is on root password.

# mysqladmin -u root password newpassword

MySQL Command to Update a root password.

# mysqladmin -u root -p oldpassword newpassword

MySQL Command to Allow the user “bob” to connect to the server from localhost using the password “passwd”.
Login as root. Switch to the MySQL db. Give privs. Update privs.

# mysql -u root -p 
mysql> use mysql; 
mysql> grant usage on *.* to bob@localhost identified by 'passwd';
mysql> flush privileges;

MySQL Command Give user privilages for a db. Login as root. Switch to the MySQL db. Grant privs. Update privs.

# mysql -u root -p 
mysql> use mysql; 
mysql> INSERT INTO db (Host,Db,User,Select_priv,Insert_priv,Update_priv,Delete_priv,Create_priv,Drop_priv) VALUES 
('%','databasename','username','Y','Y','Y','Y','Y','N'); 
mysql> flush privileges;
# or 
mysql> grant all privileges on databasename.* to username@localhost;
mysql> flush privileges;

MySQL Command to update info already in a table.

mysql> UPDATE [table name] SET Select_priv = 'Y',Insert_priv = 'Y',Update_priv = 'Y' where [field name] = 'user';

MySQL Command to Delete a row(s) from a table.

mysql> DELETE from [table name] where [field name] = 'whatever';

MySQL Command to Update database permissions/privilages.

mysql> flush privileges;

MySQL Command to Delete a column.

mysql> alter table [table name] drop column [column name];

MySQL Command to Add a new column to db.

mysql> alter table [table name] add column [new column name] varchar (20);

MySQL Command to Change column name.

mysql> alter table [table name] change [old column name] [new column name] varchar (50);

MySQL Command to Make a unique column so you get no dupes.

mysql> alter table [table name] add unique ([column name]);

MySQL Command to Make a column bigger.

mysql> alter table [table name] modify [column name] VARCHAR(3);

MySQL Command to Delete unique from table.

mysql> alter table [table name] drop index [colmn name];

MySQL Command to Load a CSV file into a table.

mysql> LOAD DATA INFILE '/tmp/filename.csv' replace INTO TABLE [table name] FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (field1,field2,field3);

MySQL Command to Dump all databases for backup. Backup file is sql commands to recreate all db’s.

# [mysql dir]/bin/mysqldump -u root -ppassword --opt > /tmp/alldatabases.sql

MySQL Command to Dump one database for backup.

# [mysql dir]/bin/mysqldump -u username -ppassword --databases databasename > /tmp/databasename.sql

MySQL Command to Dump a table from a database.

# [mysql dir]/bin/mysqldump -c -u username -ppassword databasename tablename > /tmp/databasename.tablename.sql

MySQL Command to Restore database (or database table) from backup.

# [mysql dir]/bin/mysql -u username -ppassword databasename < /tmp/databasename.sql

MySQL Command to Create Table Example 1.

mysql> CREATE TABLE [table name] (firstname VARCHAR(20), middleinitial VARCHAR(3), lastname VARCHAR(35),suffix VARCHAR(3),officeid VARCHAR(10),userid 
VARCHAR(15),username VARCHAR(8),email VARCHAR(35),phone VARCHAR(25), groups VARCHAR(15),datestamp DATE,timestamp time,pgpemail VARCHAR(255));

MySQL Command to Create Table Example 2.

mysql> create table [table name] (personid int(50) not null auto_increment primary key,firstname varchar(35),middlename varchar(50),lastnamevarchar(50) default 
'bato');

MySQL Command to Show all data in a table.

mysql> SELECT * FROM [table name];

MySQL Command to Returns the columns and column information pertaining to the designated table.

mysql> show columns from [table name];

MySQL Command to Show certain selected rows with the value "whatever".

mysql> SELECT * FROM [table name] WHERE [field name] = "whatever";

MySQL Command to Show all records containing the name "Bob" AND the phone number '3444444'.

mysql> SELECT * FROM [table name] WHERE name = "Bob" AND phone_number = '3444444';

MySQL Command to Show all records not containing the name "Bob" AND the phone number '3444444' order by the phone_number field.

mysql> SELECT * FROM [table name] WHERE name != "Bob" AND phone_number = '3444444' order by phone_number;

MySQL Command to Show all records starting with the letters 'bob' AND the phone number '3444444'.

mysql> SELECT * FROM [table name] WHERE name like "Bob%" AND phone_number = '3444444';

MySQL Command to Show all records starting with the letters 'bob' AND the phone number '3444444' limit to records 1 through 5.

mysql> SELECT * FROM [table name] WHERE name like "Bob%" AND phone_number = '3444444' limit 1,5;

MySQL Command to Use a regular expression to find records. Use "REGEXP BINARY" to force case-sensitivity. This finds any record beginning with a.

mysql> SELECT * FROM [table name] WHERE rec RLIKE "^a";

MySQL Command to Show unique records.

mysql> SELECT DISTINCT [column name] FROM [table name];

MySQL Command to Show selected records sorted in an ascending (asc) or descending (desc).

mysql> SELECT [col1],[col2] FROM [table name] ORDER BY [col2] DESC;

MySQL Command to Return number of rows.

mysql> SELECT COUNT(*) FROM [table name];

MySQL Command to Sum a column.

mysql> SELECT SUM(*) FROM [table name];

I received a snail mail letter today from the Canadian Domain Authority. Is it a scam? Well, the Canadian Domain Authority sent the unsolicited letter to me because I am the registrant of domain name (.com) that contains the name of one of the provinces of Canada in it.

In 2004 the FTC forced the Domain Registry of America to refund it’s 50,000 customers. I hope the same will happen to the Ripoff scam of the Canadian Domain Authority.

Previously, I posted about the horrible customer experience I had with 1&1 corporation when they basically fired me as a customer when my sites became too popular for their shared hosting plan. All they had to do was inform me of the issue (before shutting my sites down with no notice or warning) and I’d have gladly shelled out for a dedicated server.  Instead, and without any warning, I get a service unavailable message from 1&1. Beyond that, as I’m rushing to transfer all of my holdings out of that registrar, I encounter many error messages saying that there is a domain registration error from 1&1.

I’ve long since switched to godaddy, who has english speaking, United States based customer service, and they have blown my expectations out of the water.

Anyway, over a year after I switch, i get a promotional email from 1and1 marketing, showboating an offer of unlimited traffic. As vague as that is, i know it will mislead many customers into thinking that it means unlimited everything, when it does not!

When you talk about shared hosting, there are several factors:

• number of domains you can host (unlimited according to 1and1)
• number of GB of transfer per month This is what they are really saying is unlimited
• RAM/memory available – they don’t specify this for shared hosting, nor do they give a method for customer to monitor it. This is what will limit you before GBs of transfer does.
• CPU Time allowed – they don’t specify this for shared hosting, nor do they give a method for customer to monitor it. This is what will limit you before GBs of transfer does.

The last two, factors that you can not monitor yourself, and factors that are not called out in your “plan” are what will get you kicked off faster than any other factor (including non-payment). The idea is that you are on shared hosting, and you should use a proportionate amount of the two items – CPU Time and RAM/Memory.

My point is, the recent 1&1 ad is a deceptive marketing piece, and I call it nothing more than another scam by 1&1 ripoff web hosting.

Again, if anyone knows the direct phone numbers to any of the 1&1 corporate folks in the US, please post them below.

Content is currently being developed.

So <b>where is the Fairview overpass?</b> LOL yeah, the way the Halifax Department of Transportation worded it when they “notified the public” was a bit vague, and they used a name that is not “official”. They assumed everyone knows what the Fairview overpass is, and where it is, just like they assume everyone knows that the Provincial highway #102 is called the “bi-hi”. There are about 50 overpasses that could constitute as a “fairview overpass” in Halifax. Anyway, the <u>Fairview overpass in Halifax</u>, where the construction will be occurring, will affect you if you go 1 of two ways into the city:

1. The Bedford Highway, or
2. down Lacewood, and out to Joseph Howe Dr., toward the Windsor St. Exchange.

As you can see below, it is between point a and b on the map. You know when you leave halifax, and you pass the windsor street interchange, you can loop hard right and get yourself on the Joseph Howe Dr? Well that “overpass” you drive under, is the Fairview Overpass. It is directly before the Windsor St. Interchange, one of only 3 ways onto the peninsula that Halifax sits on (besides the bridges from Dartmouth) These include:

1. The Armdale Rotary
2. The Windsor St. Exchange
3. The Highway #102 Inbound

The majority of traffic that will not be able to use the construction route will likely divert to the highway 102 inbound route.

View Larger Map

Regardless, it’s going to make my commute 50% longer in the morning. Nice. You may have found this if you are a frustrated Halifax commuter looking for:

• where is the Halifax Fairview overpass
• Fairview overpass construction
• construction zone Fairview overpass
• construction Fairview overpass Halifax
• 2009 Fairview overpass
• alternate route Fairview overpass
• Fairview overpass work
• Fairview overpass construction site
• dates of Fairview overpass work in Halifax

What is a Disconnected Recordset?

A Disconnected Recordset is A recordset object that exists in an application, but does not have an associated data connection associated with it.

Why use a Disconnected Recordset?

The ADO Recordset is considered an extremely “rich object model” which means it provides more functionality than say, an array.
Also, you can load XML into a disconnected recordset, which means that there is no difference in your RS than if you hit a database.

How to code a Disconnected Recordset?

Here is an example of putting data from XML into a recordser, a disconnected recordset to be exact.

Const adVarChar = 200
Const adSingle = 4
Const adPersistxml = 1
Const adUseClient = 3
Const adOpenStatic = 3
Const adLockBatchOptimistic = 4
Const adStateOpen = 1

Public Function fGetXmlForRs(strFieldsCsv, intFieldLen)
	Dim objRs, arrFields, intCount, objXmlDom, objXmlRows, objXmlRow, objXmlColumns, objXmlColumn

	Set objRs  = CreateObject("ADODB.recordset") 'create disc. rs
	Set objXmlDom = CreateObject("Msxml2.DOMDocument")

	objXmlDom.LoadXML "YOUR_XML_HERE" 

	arrFields = split(replace(strFieldsCsv," ",""),",")
	For intCount = 0 To uBound(arrFields)
		objRs.Fields.Append arrFields(intCount), adVarChar, intFieldLen  'fieldname, type, size
	Next
	objRs.Open , , adOpenStatic, adLockBatchOptimistic

	Set objXmlRows = objXmlDom.selectNodes("YOUR_ROW_NODE_HERE")
	For Each objXmlRow In objXmlRows  'for each row
		intCount = 0
		set objXmlColumns = objXmlRow.selectNodes("col")
		objRs.AddNew()
		For Each objXmlColumn In objXmlColumns
			objRsLocal (arrRequestedFields(intCountCol)).value = objXmlColumn.text
			intCount = intCount + 1
		Next
		objRs.Update()
	Next		

	Set objXmlDom = Nothing
	Set fGetRntRs = objRs
	Set objRs .ActiveConnection = Nothing
End function

To use the XML to Recordset function, just call this:

Set yourNewRs = fGetXmlForRs("field1name, field2name, etc", 255)

do while not yourNewRs.eof....

Well, my website was hacked with iframe injections pointing to ageegle dot ru -ageegle.ru- last week (not this site). The hacker added malicious code to my index or default web files that included iframe tags pointing to a site called ageegle dot ru (do not visit that site) on port 80. This page, when visited, caused the site to try to download malware to the users computer.

The first thought to enter my mind was that my web host was hacked. I don’t quite remember how i ruled that out, but it was not that. I then considered that there was a vulnerability in my code, since it was a site written in classic asp with vb script that I had written entirely myself. I ruled that out as well, because I was meticulous in ensuring that there were no holes that would allow sql injection attacks, or any access to the file system itself. I did my own testing to ensure this, then hired two separate consultants to review and test the code again.

I opened the file browser within my web hosts control panel, and noticed that the modified date of the files were updated to the date the malicious code was written to them. Since I do not share my hosting password with anyone, it had to be FTP, with the credentials stolen by malware on my own computer. Many are quick to dismiss that, but it can happen easy.

I had never been hit with malware or a virus in 11 years of computing without an antivirus software, so I got cocky. I found that I got a piece of malware with a download of some plugins for dreamweaver.

Even when I changed my FTP password on the host, the spammer was able to write to my files with the iframe injections. This means that when I changed the FTP credentials in Dreamweaver, they were capturing them there.

Install at least two anti-virus applications on any development boxes you use, and scan everything. Use SFTP if you can. NEVER use pirated web development tools, as normally the keygens (exe files) contain the malware that steals passwords. Its just too damn risky.

If this has happened to you, and you are having issues getting things back on track, feel free to leave me a comment, and I will be happy to help out if I can, or at least point you in the direction of more information.

You will have found this post if you searched for any of the following:

• iframe injection
• ageegle.ru iframe
• website hacked by ageegle iframe
• website hacker iframe ftp
• index files hacked
• default files hacked
• dreamweaver infected
• keygen steal ftp password
• iframe hacked script
• web host hacked

Sites linked to in the malicious code (Don’t visit these sites):

• red-wolf.ru:8080
• pornishe.ru:8080
• daniellecsejtei.selfip.com:8080
• benparker44.is-a-chef.com:8080

Below is a draft of a “Terms and Conditions of Use” or “Disclaimer” statement template.

Website “Disclaimer” or “Terms and Conditions of Use” Template.

There are a few tags to replace in the template before publishing it to a web property:

• {{ORG_NAME}}

  – Your main or Parent Company’s Name. (e.g. the “bing” website’s parent would be “Microsoft Corp” for example)

• {{SITE_URL}} – http://www.YourURL.com
• {{SITE_NAME}} – The general operating name of your website (e.g. http://google.com/adsense Site Name would be “Google AdSense for Publishers” for example)

Scope and Purpose of this Disclaimer

This disclaimer document governs your use of our informational website. By using the website located at {{SITE_URL}} and it’s subdirectories, you agree to, and accept this disclaimer in full. If you disagree with any part of this disclaimer, do not use our website, as that condition prohibits you from doing so. {{ORG_NAME}} reserves the right to modify these terms at any time, and thus, you should check for changes before proceeding to utilize the services and content of {{SITE_NAME}}. By using this site after changes have been made to this document, you agree to accept those changes, whether or not you have reviewed them.

Rights to information published

All materials on this site are protected by copyright and intellectual property laws and are the property of {{ORG_NAME}}. Unless stated otherwise, you may access and download the materials located on {{SITE_URL}} only for personal, non-commercial use. You may not reproduce this material on your personal website, blog, social network, or any other online resource.

Any and all content (including user and visitor generated content) submitted either via email, comment forms, or any other page hosted at {{SITE_URL}} or its content aggregation systems becomes the property of {{SITE_NAME}}. {{SITE_NAME}} reserves the right to alter, remove, re-post, re-purpose, market, or trade any such content.

Our Rights to Remove or Reproduce any User-Generated Material

For the purposes of this condition, the term “user-generated material” shall refer to any information, content, or any other media uploaded, posted, emailed, submitted, or otherwise communicated to {{SITE_NAME}} via any method at any page on {{SITE_URL}} or any other content communication or submission medium or forum.

By sharing any contribution or user-generated content (including any text, photographs, graphics, video, audio or any other type of media or content) with {{SITE_NAME}} ({{SITE_URL}}) you agree to grant us, free of charge, permission to use the material in any way we deem fit (including the modification, reproduction, repurposing, or deletion of it). You hereby confirm that your contribution is your own original work, is not defamatory and does not infringe upon any laws of the country from which you are utilizing this site, nor the laws of Canada or The United States of America, and that you have the full rights to accept this condition.

Site content (quality, accuracy and use)

Visitors who use this website and rely on any information do so at their own risk.

This Web site and the attached documents are provided “as is” without warranty of any kind, either express or implied, including, but not limited to, the implied warranties of merchantability and fitness for a particular purpose. Information found at {{SITE_URL}} will not always be up to date and cannot necessarily be relied upon.

The information is intended solely for entertainment purposes and may not be used as a substitute for professional advice and/or information, as circumstances will vary from person to person. You should not act or rely upon this information without seeking professional advice. Do not attempt any of the suggested actions, solutions, remedies, or instructions found on this website without first consulting with a qualified professional. They are not intended to be nor do they constitute actionable professional advice. Transmission of this information is not intended to create a professional-client relationship between {{SITE_NAME}} (or it’s parent, {{ORG_NAME}}) and you.

The owners, editors, contributors, administrators, and other staff of {{SITE_NAME}} (a {{ORG_NAME}} web property) are not qualified professionals, and are simply aggregating information found online for entertainment purposes only.

By using this website, you hereby forfeit any and all claims, past, present, and future, against the owners, editors, contributors, administrators, and other staff of {{SITE_NAME}} (a {{ORG_NAME}} web property).

Restrictions on who can use the website

If you are under 18, please get a parent’s or guardian’s permission before taking part in any {{SITE_NAME}} community. Never reveal any personal information about yourself or anyone else (for example, school, telephone number, your full name, home address or email address).

By visiting any page at {{SITE_URL}} you understand that “adult” content may be encountered that is not suitable for children. You must be at least 18 years of age or have a parent/guardian present while viewing any page or other correspondence or content from the {{SITE_NAME}} website, (which includes all content and code from any page hosted at or within {{SITE_URL}}, or any content or code relating to or from this site that was transmitted via email or other means). {{SITE_NAME}} (or it’s parent, {{ORG_NAME}}) can not be held responsible for any harm that is experienced, real or perceived, from viewing, following, or contributing, of any sort of content on this site.

External links – limiting liability for links to other web sites

We are not responsible for the contents or reliability of any other websites to which we provide a link, and we do not, expressly or otherwise, endorse the views and/or content expressed within those sites.

The Actions and Opinions of Other Users

You must not use this website in any way which is unlawful, illegal, fraudulent or harmful, or in connection with any unlawful, illegal, fraudulent or harmful purpose or activity. Some content found on the pages of {{SITE_NAME}} within {{SITE_URL}} and its subdirectories is created by members of the public. The views expressed are theirs and unless specifically stated are not those of {{SITE_NAME}} (or it’s parent, {{ORG_NAME}}). We accept no responsibility for any loss or harm incurred from the use of this website or any of it’s information or content.

Viruses, Damage and Availability

{{SITE_NAME}} (or it’s parent, {{ORG_NAME}}) makes no warranty or claim that functions available on this website will be uninterrupted or error free, that defects will be corrected, or that the server that makes it available, nor the content itself is and/or will be free of viruses, bugs, or other malicious code. You acknowledge that it is your responsibility to implement sufficient procedures and virus checks (including anti-virus and other security checks) to satisfy your particular requirements for the accuracy of data input and output, and for the security of yourself and the device used by you to view any content from this website.

Legal jurisdiction

The Federal laws of Canada and the Provincial laws of Nova Scotia shall otherwise govern your use of the site where these terms and conditions are not clear or incomplete and you hereby agree to submit to the exclusive jurisdiction of the Canadian Federal and Provincial court system.

Limited Liability

{{SITE_NAME}}, (and it’s parent, {{ORG_NAME}}) and its officers, employees, contractors or content providers shall not be liable for any loss or damage arising from or otherwise in connection with your use of any content, information, function, or service of {{SITE_NAME}} at any location within {{SITE_URL}} or other related location (such as content feeds, links, emails, letters, documents, and other company products or correspondence).

Though we make a reasonable effort to maintain the resources of this website, they will, from time to time, become out of date, be incorrect, erroneous, or otherwise inappropriate. As noted above, by using this website you agree that you will not follow any instruction, suggestion, step, list, tutorial, or other content on this website or any of its content posted elsewhere untill you have appropriately consulted with a licensed professional who is unrelated to this site or it’s parent company in any way.

If you are looking for a Cross Browser Compatible CSS Opacity code, you need look no further. The following provides 100% opacity (which is the same as 0% transparency.)

1
2
3
4
5
6
7
8
9
10

Body {
 
...your body css...
 
-moz-opacity: 1.0 !important;
-webkit-opacity: 1.0!important;
-ms-filter:"progid:DXImageTransform.Microsoft.Alpha(Opacity=100)" !important;
filter: alpha(opacity=100) !important;
opacity: 1.0 !important;
}

The key is ensuring that the order of the opacity entries are kept in this format.

The -webkit- opacity handles chrome, the -mox- handles FF, Netscape, Mozilla, the -ms- handles older IE versions, like 5 and 6.

• best css opacity for all browsers.
• opacity css cross browser?
• how to use css opacity
• what is css opacity
• cross browser opacity css
• opacity css for IE6, IE5