nAzRIKs Blog

Installing MySQL 5.7 Community Release on CentOS/RedHat 7/6

2019-10-31T14:42:00.000+08:00

Step 1

Enable MySQL Repository

CentOS / Redhat 7

yum localinstall https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm

CentOS / Redhat 6

yum localinstall https://dev.mysql.com/get/mysql57-community-release-el6-9.noarch.rpm

Step 2

Install MySQL Server

yum install mysql-community-server

Step 3

Start MySQL Service

service mysqld start

Step 4

Get the temporary root password

grep 'A temporary password' /var/log/mysqld.log |tail -1

Initialize MySQL

/usr/bin/mysql_secure_installation

My recommendation is to choose yes for all the prompt

Step 5

Login to MySQL

mysql -h localhost -u root -p

Verify the installed MySQL Version

mysql -v

MySQL CLI Cheat Sheet

2019-10-30T13:59:00.003+08:00

Bold item is your own value e.g: mysql -u nazriks -p

Credit to Sven for this great list

Access CLI:

mysql -u [username] -p
(press enter key & it will prompt for password)

Show all databases:

show databases;

Accessing a database:

mysql -u [username] -p [databasename]
(press enter key & it will prompt for password)

Create new database:

create database [databasename];

Select database:

use [databasename];

Determine what database you're currently on:

select database();

Show all tables:

show tables;

Show table structure:

describe [tablename];

List all indexes on a table:

show index from [tablename];

Create new table with columns:

CREATE TABLE [tablename] ([columnname1] VARCHAR(120), [columname2] DATETIME);

Adding a column:

ALTER TABLE [tablename] ADD COLUMN [columname] VARCHAR(120);

Adding a column with an unique, auto-incrementing ID:

ALTER TABLE [tablename] ADD COLUMN [columname] int NOT NULL AUTO_INCREMENT PRIMARY KEY;

Inserting a record:

INSERT INTO [tablename] ([columnname1], [columnname2]) VALUES ('[columnname1-value]', [comnname2-value]');

MySQL function for datetime input:

NOW()

Selecting records:

SELECT * FROM [tablename];

Explain records:

EXPLAIN SELECT * FROM [tablename];

Selecting parts of records:

SELECT [columnname1], [columnname2] FROM [tablename];

Counting records:

SELECT COUNT([columnname]) FROM [tablename];

Counting and selecting grouped records:

SELECT *, (SELECT COUNT([columnname]) FROM [tablename]) AS count FROM [tablename] GROUP BY [columnname];

Selecting specific records:

SELECT * FROM [tablename] WHERE [columnname] = [value]; (Selectors: <, >, !=; combine multiple selectors with AND, OR)

Select records containing [value]:

SELECT * FROM [tablename] WHERE [columnname] LIKE '%[value]%';

Select records starting with [value]:

SELECT * FROM [tablename] WHERE [columnname] LIKE '[value]%';

Select records starting with val and ending with ue:

SELECT * FROM [tablename] WHERE [columnname] LIKE '[val_ue]';

Select a range:

SELECT * FROM [tablename] WHERE [columnname] BETWEEN [value1] and [value2];

Select with custom order and only limit:

SELECT * FROM [tablename] WHERE [columnname] ORDER BY [columnname] ASC LIMIT [value]; (Order: DESC, ASC)

Updating records:

UPDATE [tablename] SET [columnname] = '[updated-value]' WHERE [columnname] = [value];

Deleting records:

DELETE FROM [tablename] WHERE [columnname] = [value];

Delete all records from a table (without dropping the table itself):

DELETE FROM [tablename];
(This also resets the incrementing counter for auto generated columns like an id column.)

Delete all records in a table:

truncate table [tablename];

Removing table columns:

ALTER TABLE [tablename] DROP COLUMN [columnname];

Deleting tables:

DROP TABLE [tablename];

Deleting databases:

DROP DATABASE [databasename];

Custom column output names:

SELECT [columnname] AS [custom-columnname] FROM [tablename];

Export a database dump (more info here):

mysqldump -u [username] -p [database] > db_backup.sql

Use --lock-tables=false option for locked tables (more info here).

Import a database dump (more info here):

mysql -u [username] -p -h [localhost] [databasename] < db_backup.sql

Logout:

exit;

Aggregate functions

Select but without duplicates:

SELECT distinct name, email, [acception] FROM [owners] WHERE [acception] = [1] AND date >= [2015-01-01 00:00:00]

Calculate total number of records:

SELECT SUM([columnname]) FROM [tablename];

Count total number of [columnname] and group by [category-columnname]:

SELECT [category-columnname], SUM([columnname]) FROM [tablename] GROUP BY [category-columnname];

Get largest value in [columnname]:

SELECT MAX([columnname]) FROM [tablename];

Get smallest value:

SELECT MIN([columnname]) FROM [tablename];

Get average value:
SELECT AVG([columnname]) FROM [tablename];

Get rounded average value and group by [category-columnname]:

SELECT [category-columnname], ROUND(AVG([columnname]), 2) FROM [tablename] GROUP BY [category-columnname];

Multiple tables

Select from multiple tables:

SELECT [tablename1].[columnname], [tablename1].[another-columnname], [tablename2].[columnname] FROM [tablename1], [tablename2];

Combine rows from different tables:

SELECT * FROM [tablename1] INNER JOIN [tablename2] ON [tablename1].[columnname] = [tablename2].[columnname];

Combine rows from different tables but do not require the join condition:

SELECT * FROM [tablename1] LEFT OUTER JOIN [tablename2] ON [tablename1].[columnname] = [tablename2].[columnname];
(The left table is the first table that appears in the statement.)

Rename column or table using an alias:

SELECT [tablename1].[columnname] AS '[value]', [tablename2].[columnname] AS '[value]' FROM [tablename1], [tablename2];

Users functions

List all users:

SELECT User,Host FROM mysql.user;

Create new user:

CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';

Grant ALL access to [user] for * tables on [databasename]:

GRANT ALL ON [databasename].* TO '[user]'@'[localhost]';

Find out the IP Address of the MySQL Host

SHOW VARIABLES WHERE Variable_name = 'hostname'; (source)

Finding Windows Product Key Inside Pirated Windows CD

2009-08-27T15:32:00.003+08:00

Just a short entry.. it might work on self install original cd too.

Insert the CD
Right Click on the CD drive > click Explore/Open
go to I386 folder
find a file named WINNT.SIF
right click the file > open with > notepad
the product key is located under [UserData]

New Encryption Chip That Will End Game Piracy

2008-05-27T20:52:00.003+08:00

Speaking at Wedbush Morgan Securities annual Management Access Conference,
Atari founder said that gaming piracy will soon be a thing in the past thanks to this new chip

"There's a new stealth encryption chip that will be on most of the computer motherboard that are coming out now" he said.

According to him, the game developer will be able to encrypt their game with an absolutely verifiable private key which is uncrackable by people.

"What that says is that in the games business we will be able to encrypt with an absolutely verifiable private key in the encryption world - which is uncrackable by people on the internet and by giving away passwords - which will allow for a huge market to develop in some of the areas where piracy has been a real problem."

He however thinks that piracy of movies and music are unstoppable.

"if you can watch it and you can hear it, you can copy it."
"Games are a different thing, because games are so integrated with the code. The TPM will, in fact, absolutely stop piracy of gameplay."

Wow that looks like a challenge . I would like to see the outcome

Shape-Shifting Malware Hits the Web

2008-05-17T15:44:00.004+08:00

Stony Stevenson writes to tell us that in a recent interview, Marc Henauer has revealed that security researchers are falling behind now that malware is starting to be able to change its signature every few hours.

Unfortunately the know-how and construction kits used to create this shape-shifting threat are now readily available and are unleashing a wave of malware based on social engineering techniques. [...] Sweeney believes that a non rules-based monitoring process must be set up to defend all ingress and egress points covering SMTP, DNS, HTTP(s), IM etc.

Source Slashdot

Dell Will Continue to Install XP Past of Cut-off Date

2008-04-26T05:38:00.004+08:00

Some facts from the Article

Fact 1: As of June 30, large computer manufacturers such as Dell and Hewlett-Packard can no longer offer Windows XP preinstalled on new computers, though Microsoft has said it would consider re-evaluating the deadline if there's enough customer demand.

Fact 2: Anyone who buys a copy of either the Business or Ultimate versions of Vista is entitled to also get Windows XP Professional .* Each computer manufacturer decides whether, or how, to implement this.

According to CNet, Dell will continue to install Windows XP for you on their PC even after the date given by Microsoft.

When selecting your operating system, you will see an option called "Genuine Windows® Vista Business BONUS" and "Genuine Windows Vista Ultimate BONUS." With these options, you may...have Dell factory install Windows XP Professional. You will also receive a backup media disc for Windows XP Professional, as well as the media for Windows Vista.

In other words, Dell provides optical discs for both XP and Vista, so you can change over at any time. This is not like
Apple's Boot Camp, however; the computer can have only one operating installed on the hard disk at a time. But Dell provides technical support for both XP and Vista. Whether its tech support is worthwhile is another matter.

I hope other company will follow their steps to continue supporting XP at least until it became "more stable and worthy" (well.. even XP got their own problem back then when Microsoft first release it).

not to you.. especially not to you

2008-04-23T05:16:00.004+08:00

Drathos writes "From MTV Movies Blog by way of WoW Insider: Everyone's least favorite director, Uwe Boll approached Blizzard about making a World of Warcraft movie. Their response? "We will not sell the movie rights, not to you ... especially not to you.""

Source : Slashdot

Well I'd say thank god! For anyone who didnt know who's Uwe Boll, he's a director, producer and screenwriter that has created lots of bad films (yes! i mean it.. BAD) based on video games.. here's a some of his films :

Alone In The Dark
House of The Dead
Bloodrayne I & II (and currently making the 3rd)

According to wikipedia..

"When rumors surfaced that Boll had expressed interest in a Metal Gear Solid movie, and claimed to have been given a script to read, Metal Gear creator Hideo Kojima responded in his audioblog HIDECHAN, "Absolutely not! I don't know why Uwe Boll is even talking about this kind of thing. We've never talked to him. It's impossible that we'd ever do a movie with him.""

Read more about him on wikipedia

PayPal Plans To Ban Unsafe Browsers

2008-04-18T17:08:00.002+08:00

Alternative Details brings news that PayPal is developing a plan to stop users from accessing its financial services if they aren't using browsers with anti-phishing protection. PayPal is recommending the use of blacklists, anti-fraud warning pages, and EV SSL certificates. Browsers without anti-phishing features will be considered "unsafe." It seems likely Safari will be included in this category given PayPal's warning about the Apple browser last month.

"'At PayPal, we are in the process of reimplementing controls which will first warn our customers when logging in to PayPal of those browsers that we consider unsafe. Later, we plan on blocking customers from accessing the site from the most unsafe--usually the oldest--browsers,' he declared. Barrett only mentioned old, out-of-support versions of Microsoft's Internet Explorer among this group of 'unsafe browsers,' but it's clear his warning extends to Apple's Safari browser, which offers no anti-phishing protection and does not support the use of EV SSL certificates."

Source: Slashdot

Dreamworks Acquires Rights for Ghost in the Shell

2008-04-17T17:06:00.002+08:00

Anonymous GiTS fan noted a Variety story informing us that DreamWorks has acquired the rights to Ghost in the Shell and has plans to produce a "3D Live Action" version of the popular anime. This happened apparently because Spielberg is a fan. He says "'Ghost in the Shell' is one of my favorite stories ... It's a genre that has arrived, and we enthusiastically welcome it to DreamWorks." I hope they add a talking donkey.

Source: Slashdot

What are people googling

2008-04-12T14:19:00.003+08:00

Source : I-am-bored

Microsoft Extend XP through 2010 for Ultra Low Cost PCs

2008-04-04T13:02:00.004+08:00

Microsoft confirmed Thursday that it will extend the sales of Windows XP Home to OEMs beyond the current deadline of June 30, 2008, to accommodate a new class of ultra-low-cost PCs (ULCPCs) that are just beginning to pepper the market.

Windows XP Home will be available for OEMs to install on ULCPCs either until June 30, 2010, or one year after the availability of the next client version of Windows, code-named Windows 7 -- whichever date comes later. The IDG News Service previously reported that Microsoft would extend XP's life for these machines.

Neighbours Steal Ur Wi-fi? Have Fun With Them!

2008-04-02T09:27:00.006+08:00

so, you find out that your neighbours are using your network without your permission.. Kill the links or you can have fun with them~!

Link

Edit: Link Fixed >_<

60% of Photoshop User are PIRATES~!

2008-03-29T04:43:00.003+08:00

Image Credits to ICanHasCheezeBurger
So here it is… the one week results from our previous poll on software piracy. In that short time, we’ve had nearly 500 photographers cast their votes and the outcome is quite interesting. It looks like Adobe’s high-end photo editing software packages (like Photoshop and Lightroom) are hot items in the pirated software market.

Read More

Well.. my comment is... YARRR~! XD

NVIDIA Quad SLI Dissapoints

2008-03-27T06:02:00.001+08:00

Vigile writes

"While the death of PC gaming might be exaggerated, it's hard not to see the issues gamers have with the platform. A genre that used to dominate innovation in the field now requires a $1200 piece of graphics technology just to participate, and that's just plain bad for the consumer. NVIDIA's SLI technology was supposed to get a boost today by going from two GPUs to four GPUs with the introduction of Quad SLI but both PC Perspective and HardOCP seem to think that NVIDIA drastically missed the mark by pushing an incredibly expensive upgrade that really does nothing for real-world game play and performance. If PC gamers are left with these options to save them from consoles, do they even have a chance?"

Source: Slashdot

The World Lightest Phone

2008-03-26T10:48:00.002+08:00

Image Credit to CrunchGear

According to CrunchGear, The Guinness Book of World Records has named the Modu mini phone “the lightest mobile phone in the world.” The phone, which we saw at MWC this year, weighs a mere 1.4 ounces and is .3 inches thick. Modu received a $100 million cash infusion last week.

Source : CrunchGear

Go to Modu's Official Website for more info about this phone.

The Most Disturbing Teddy Bear Ever!!

2008-03-26T10:45:00.002+08:00

uh.. i can only say... "what the hell?!! put it back on!!"

link

The Real Reason We Use Linux

2008-03-22T11:35:00.002+08:00

Vlad Dolezal writes

"We tell people we use Linux because it's secure. Or because it's free, because it's customizable, because it has excellent community support... But all of that is just marketing BS. We tell that to non-Linux users because they wouldn't understand the REAL reason."

The answer to his question probably won't surprise you.

Source: Slashdot

Windows Vista SP1 Meeting Sour Reception In Places

2008-03-22T10:28:00.007+08:00

Stony Stevenson writes

"A day after it was released for public download, Windows Vista SP1 is drawing barbs from some computer users who say the software wrecked their systems. 'I downloaded it via Windows Update, and got a bluescreen on the third part of the update,' wrote 'Iggy33' in a comment posted Wednesday on Microsoft's Vista team blog. Iggy33 was just one of dozens of posters complaining about Vista Service Pack 1's effect on their PCs. Other troubles reported by Vista SP1 users ranged from a simple inability to download the software from Microsoft's Windows Update site to sudden spikes in memory usage. To top it all off, the service pack will not install on computers that use peripheral device drivers that Microsoft has deemed incompatible."

Source: Slashdot

Well I guess for those who still planning to upgrade to vista would think twice now...

Anyway, here's someone who posting his experience trying vista.. Link

What are the best Web 2.0 apps? The finalist are waiting for your vote~!

2008-03-19T15:32:00.003+08:00

Have you vote for this year Webware 100 Award yet? if no I please do so~! XD

For those who don't know what's Webware is.. here's a little description I "stole" from the website LOL:

There's a shift underway in how people use computers and the Internet. Every day more utility is being delivered over the Web. Full applications can now be run in a browser, accessible from any computer. Software? It's no longer required. Software is becoming Webware.

There are different types of Webware.

Productivity applications. Microsoft may own the desktop, but not the Web. Online, Google has solid productivity apps. And there are dozens of upstarts in this market too.
Data-driven applications. Many new online services rely on real-time data that simply could not be encapsulated into software. Examples include Google Maps, Zillow and Farecast.
Community services. Webware enables people to network, share their lives, and work together. Examples are MySpace, LinkedIn, YouTube, and SmartSheet.

Webware.com is the site where computer users can learn about new and useful Web applications.

Look for more new features to roll out in Webware.com, too. Stay tuned!

and now here's the last year winners

so... hurry up~! and vote!

Webware 100 votes cast so far: 1,632,285

Google Sky Now Available Through Your Browser

2008-03-17T00:53:00.001+08:00

Ars Technica brings word that Google Sky, formerly only available as an extension of the Google Earth software, is now accessible through your web browser. The interface of Google Sky is quite similar to that of Google Maps, complete with search and alternate views by spectrum. The story also mentions (and more importantly, links) ten of the more interesting sights. We discussed Google Sky's initial release last year. Quoting: "Visible light only shows us a small picture of the entire universe; non-visible spectra such as ultraviolet (UV), infrared and X-ray hold a whole other world of information. Here is where Google Sky becomes very cool. There are three more sections that highlight fantastic images from the Chandra X-Ray Observatory, the GALEX Evolution Explorer (UV), and the Spitzer Space Telescope (IR). What makes these very cool is that under each selected body there is a slider that will change the displayed image back and forth between the visible and invisible spectrum.

Source: Slashdot

Intel Confirm 160GB Flash Drive Will Ship In 2nd Quarter 2008!

2008-03-14T02:21:00.003+08:00

the company confirmed that it is close to unveiling a new line of solid-state drives for laptop and notebook PCs that will feature a storage capacity up to 160GB.

An Intel spokesman said that the chip maker will introduce 1.8-in. and 2.5-in. solid-state drives offering between 80GB and 160GB diskless storage during the second quarter of 2008.

Read More

Find Information About Ram on Your Pc - wikiHow

2008-03-10T07:07:00.001+08:00

How to Find Information About Ram on Your Pc

from wikiHow - The How to Manual That You Can Edit

When a computer feels slow it sometimes needs some more RAM (random Access memory). This is easy to obtain but you have to use the right type for your PC.

Steps

Go to the website: http://www.crucial.com/systemscanner/loader.asp?agree=yes&tabid=AM&pagename=index%2Easp
Follow the prompts, and agree for the scanner to scan your pC.
Record the data about your memory it provides.
Buy RAM accordingly.

Tips

Record the data for future use.
Make sure the RAM is suited to your PC before opening the packet.

Warnings

PC can only hold a limited amount of RAM

Related wikiHows

Article provided by wikiHow, a collaborative writing project to build the world's largest, highest quality how-to manual. Please edit this article and find author credits at the original wikiHow article on How to Find Information About Ram on Your Pc. All content on wikiHow can be shared under a Creative Commons license.

Cool Music using ONLY sounds from windows xp and 98!

2008-02-22T02:28:00.003+08:00

Whoever he is.. me must really freakin genius (and having too much free time i guess) to come out with this music

Shutdown Your Computer Remotely

2008-01-19T05:33:00.000+08:00

Today i will teach you how to shutdown your computer remotely from another computer on your network (let say you're using computer 1 upstair and want to shutdown computer 2 downstair)

first thing first...

You need..

Administrator account on the target computer
The target computer ip address or the computer name
windows xp or vista

Now the method..

1st Method

Click start >> Run and type cmd
Type shutdown -m \\computername -s
The -s tells the computer to shutdown.. you can change it to -r for restart

2nd Method

Click Start >> Run and type shutdown -i

this one is easier and you can shutdown more than 1 computer at once...

note that this method require you to put reason why you want to shutdown the computer

that's it.. as for 1st method.. you can also make a shortcut and put the command on the shortcut path.. then double click the shortcut to shutdown the target computer :p

next time i'll tell you how to shutdown your computer by using cellphone :p

WTF Ads Of The Day

2008-01-19T04:18:00.000+08:00

Well.. i dunno what to say... just watch it >_< click on this post title to watch