MySql Database Programming

NEWS CONTENTS

• 20170220 : How to delete or remove a MySQL-MariaDB user account on Linux or Unix ( Feb 20, 2017 , www.cyberciti.biz )

Old News ;-)

Perl Database Programming

• Paperback: 572 pages ; Dimensions (in inches): 1.22 x 9.20 x 7.40
• Publisher: John Wiley & Sons; 1 edition (October 28, 2002)
• ISBN: 0764549561
  
• Average Customer Review: Based on 3 reviews.
• Amazon.com Sales Rank: 335,869

MySQL and Perl for the Web by Paul DuBois

• Paperback: 552 pages ; Dimensions (in inches): 1.15 x 9.03 x 7.03
• Publisher: SAMS; 1st edition (August 3, 2001)
• ISBN: 0735710546 | All Editions
  
• Average Customer Review: Based on 24 reviews. Write a review.
  
• Amazon.com Sales Rank: 41,954
  (Publishers and authors: improve your sales)

It lacks what...?, October 23, 2001
Reviewer: sherzodr (see more about me) from East Lansing, MI USA

If you know some Perl and some MySQL, please, DO by
"MySQL and Perl for the Web" by Paul DeBois and figure out
how those fancy web applications out there are made and learn
how to be able to write one.

Paul's "MySQL and Perl for the Web" touches upon some topics
that NONE OF THE BOOKS out there ever covered in so much details.

The style and examples are amazing. He makes use of Perl5's Object
Oriented features which itself tells you that it's a professional
textbook for professional web-programmers.

The book teaches you neither Perl nor MySQL from basics. It
assumes you already have some basic knowledge of Perl and MySQL.
So it starts off at the most fun part without waisting neither his nor
the readers' time.

Here I'll go over the chapters in case the table of contents
don't tell you much (they didn't to me).

Chapter 1 and chapter 2 go over some basic things that you need
in order to understand and/or try out the examples in the book.

Chapter 2 goes over configurting your MySQL and Apache. I believe
if you are on a hosting service, this should've been done for you already.
It also teaches you to write "A Simple Web-Based Application - To-do List
Maintenance". Although the application doesn't require a lot of
brains to create, but it does cover some basic concepts that
you'll be using all the time in web-programming.

Chapter 3 gives some information on "Improving Performance with mod_perl"
and how to write scripts that work in mod_perl compiled servers.

Chapter 4, "Generating and Proccessing Forms" goes over "Form Anatomy"
and does introduce some concepts of "Form Desgin Issues"

Chapter 5, "Writing form-Based applications" is probably the wealthiest
chapter of the book. Following sections are available under this chapter:
"Product registration", "Using Email from Within Applications", "Running a
Giveaway contest", "Conducting a Poll", "Storing and Retriving Images",
"Electronic Greeting Cards - Send a Friend a Greeting".
This chapter lasts over 80 pages.

Chapter 6, "Automating the Form-Handling process" introduces some
concepts that you can make use of in order to automate the form handling
process through the use of MySQL's table metadata, which is available
through DESC table_name ( or SHOW COLUMNS FROM table_name ) query.
Using his concept I introduced a new module to CPAN.org, MySQL::TableInfo.

Chapter 7, "Performing Searches" covers "Writing a Form-Based Serch
Application" and "Extending" it. It also introduces the concept of
"Link-Based Navigation". It also teaches you how to split the results of the search
over several pages; suppose you have a result of 100 rows in your search, and
you show only 20 results at a page, and provide [previos] and [next] links
so that users could navigate over your pages. Neat, isn't it?

Cahpter 8, "Session Management" was the one I have been wating for so long.
It goes over some "State Maintenance Techqniques" used in web applications, then
introduces the most favorite one, "Active Client Identification" method.
The sections the chapter covers are: "State Maintenance Techqniques", "Implementing
Session Support", "Expiring Sessions", "Storing User Prefernces", "Implementing Resumable
Sessions" and "When Sessions aren't enough"

Chapter 9, "Security and Privacy" teaches you the ways of precaution you could
take against "bad guys" ( hackers? ) to insure the security of your site/database.
Also shows you how to write a login page to provide access to some sensitive information
using the techniques he just mentioned.

Chapter 10, "E-Commerce Applications" covers such topics as Shopping carts,
credit card validation and in the end of the chapter completed a fully operating
commercial web-site.

Although the book concentrates on MySQL, I wrote several applications that make use of
Berkeley Database using the same techniques as Paul suggested. I tell you, I lerned a lot....

This is the most important book in my library (of over 300), January 29, 2004

David M. Roberts (see more about me) from Palm City, Florida United States

Like many others, I wish I'd seen this book long ago.

The attention to detail and accuracy of the examples is just incredible!

This is by far the most used reference book in my library. After repeatedly having to tape the book together, I finally gave it away and bought a new one.

Following his examples eliminates many potential pitfalls that would otherwise result in hours of troubleshooting.

I can't imagine how I would have ever learned this information without the expert advice of the author, Paul DuBois. His coverage of CGI.pm is essential as well as his list of other books to read.

I think I have all his other books as well.

He even returned email almost immediately!

My only complaint is that it isn't bound in leather!

Clear explanations and excellent examples, November 3, 2003

Stan Burkes from Roanoke, VA USA

This is an excellent book. I knew my way around Perl and had done a few relatively simple CGIs before being handed a project to build an application that would allow 50 or 60 employees to enter several thousand customer complaints and email them to the right recipents based on the complaint content. I had a three-week deadline.

I bought the book and started patching elements of the example applications together until I what I needed almost working. One problem delayed me a couple of days so I emailed DuBois with a question and received a solution within the hour.

I'd recommend this book to anyone who has a moderate grasp of Perl and Apache. It's one of the most lucid computer books I've ever read.

MySQL and Perl but no templates?, August 20, 2003

Dave Howorth from Herts, United Kingdom

This isn't a complete review but readers should be aware that this book does NOT cover templates (it doesn't appear in the contents or the index). There's no mention of Template Toolkit or HTML::Template, for example. (Text::Template and HTML::Mason get mentioned as an aside, but that's it) Similarly, there are three chapters on forms, but no mention of CGI::FormBuilder.

Seems like a big omission to me. YMMV.

very good intermediate book, November 13, 2002

broadwaynyc (see more about me) from NJ United States

As I emailed Paul DuBois, I wish there was a MySQL-PHP as good as this one. I prefer to write in PHP. (I bought and sold MySQL and PHP for Web Development by Welling and Thompson. - just didn't like it)

Even though I'm not keen on using Perl - it's a preference, this book is excellent for learning good practices in writing scripts for various tasks.

This book is best for someone who's somewhat familiar with Perl and MySQL. So far, through the first 5 chapters, it has not been Perl intensive at all which is good for me.

The coverage of forms and form elements is very helpful. I cannot wait to read the chapter about storing and retrieving images.

[Feb 20, 2017] How to delete or remove a MySQL-MariaDB user account on Linux or Unix

Feb 20, 2017 | www.cyberciti.biz

How to delete or remove a MySQL/MariaDB user account on Linux or Unix by Vivek Gite on February 15, 2017 last updated February 16, 2017 in Linux , MySQL , UNIX I created a MySQL / MariaDB user account using this page . Now, I have deleted my wordpress blog and I want to delete that user account including database too. How do I delete or remove a MySQL or MariaDB user account on Linux or Unix-like system using mysql command line option?

Both MySQL and MariaDB is an open source database management system. In this quick tutorial, you will learn how to delete ore remove user account in MySQL or MariaDB database on Linux or Unix-like system.

Warning : Backup your database before you type any one of the following command.

Step 1 – Steps for removing a MySQL/MariaDB user

If you decided to remove open source application such as WordPress or Drupal you need to remove that user account. You need to remove all permissions/grants, and delete the user from the MySQL table. First, login as mysql root user to the MySQL/MariaDB server using the shell, run:
$ mysql -u root -p mysql
OR
$ mysql -u root -h server-name-here -p mysql
Sample outputs:

Fig.01: The MySQL/MariaDB shell

Step 2 – List all mysql users

Once you have a MySQL or MariaDB prompt that looks very similar to fig.01, type the following command at mysql> or mariadb> prompt to see a list of MySQL/MariaDB users:
mariadb> SELECT User,Host FROM mysql.user;
Sample outputs:

Fig.02: How to see/get a list of MySQL/MariaDB users accounts
In this above example, I need to delete a mysql user named 'bloguser'@'localhost'.

Step 3 – List grants for a mysql user

To see what grants bloguser have, enter:
mariadb> SHOW GRANTS FOR 'bloguser'@'localhost';
Sample outputs:

Fig.03: Display user grants
Where,

1. bloguser – Mysql/Maridb user name
2. localhost – Mysql/Mariadb host name
3. mywpblog – Database name

Step 4 – Revoke all grants for a mysql user

Type the following sql command:
mariadb> REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'bloguser'@'localhost';
Sample outputs:

Query OK, 0 rows affected (0.00 sec)

Step 5 – Remove/Delete the user from the user table

Type the following sql command:
mariadb> DROP USER 'bloguser'@'localhost';
Sample outputs:

Query OK, 0 rows affected (0.00 sec)

Step 6 – Delete the database

Type the following command:
mariadb> DROP DATABASE mywpblog;
Sample outputs:

Query OK, 0 rows affected (0.00 sec)

And there you have it. A MySQL/MariaDB user deleted or removed from the server on Unix or Linux via command line option.

Recommended Links

Softpanorama Recommended

Top articles

Sites

Top articles

Sites

...

Etc

Society

Groupthink : Two Party System as Polyarchy : Corruption of Regulators : Bureaucracies : Understanding Micromanagers and Control Freaks : Toxic Managers :   Harvard Mafia : Diplomatic Communication : Surviving a Bad Performance Review : Insufficient Retirement Funds as Immanent Problem of Neoliberal Regime : PseudoScience : Who Rules America : Neoliberalism  : The Iron Law of Oligarchy : Libertarian Philosophy

Quotes

War and Peace : Skeptical Finance : John Kenneth Galbraith :Talleyrand : Oscar Wilde : Otto Von Bismarck : Keynes : George Carlin : Skeptics : Propaganda  : SE quotes : Language Design and Programming Quotes : Random IT-related quotes :  Somerset Maugham : Marcus Aurelius : Kurt Vonnegut : Eric Hoffer : Winston Churchill : Napoleon Bonaparte : Ambrose Bierce :  Bernard Shaw : Mark Twain Quotes

Bulletin:

Vol 25, No.12 (December, 2013) Rational Fools vs. Efficient Crooks The efficient markets hypothesis : Political Skeptic Bulletin, 2013 : Unemployment Bulletin, 2010 :  Vol 23, No.10 (October, 2011) An observation about corporate security departments : Slightly Skeptical Euromaydan Chronicles, June 2014 : Greenspan legacy bulletin, 2008 : Vol 25, No.10 (October, 2013) Cryptolocker Trojan (Win32/Crilock.A) : Vol 25, No.08 (August, 2013) Cloud providers as intelligence collection hubs : Financial Humor Bulletin, 2010 : Inequality Bulletin, 2009 : Financial Humor Bulletin, 2008 : Copyleft Problems Bulletin, 2004 : Financial Humor Bulletin, 2011 : Energy Bulletin, 2010 : Malware Protection Bulletin, 2010 : Vol 26, No.1 (January, 2013) Object-Oriented Cult : Political Skeptic Bulletin, 2011 : Vol 23, No.11 (November, 2011) Softpanorama classification of sysadmin horror stories : Vol 25, No.05 (May, 2013) Corporate bullshit as a communication method  : Vol 25, No.06 (June, 2013) A Note on the Relationship of Brooks Law and Conway Law

History:

Fifty glorious years (1950-2000): the triumph of the US computer engineering : Donald Knuth : TAoCP and its Influence of Computer Science : Richard Stallman : Linus Torvalds  : Larry Wall  : John K. Ousterhout : CTSS : Multix OS Unix History : Unix shell history : VI editor : History of pipes concept : Solaris : MS DOS :  Programming Languages History : PL/1 : Simula 67 : C : History of GCC development :  Scripting Languages : Perl history   : OS History : Mail : DNS : SSH : CPU Instruction Sets : SPARC systems 1987-2006 : Norton Commander : Norton Utilities : Norton Ghost : Frontpage history : Malware Defense History : GNU Screen : OSS early history

Classic books:

The Peter Principle : Parkinson Law : 1984 : The Mythical Man-Month :  How to Solve It by George Polya : The Art of Computer Programming : The Elements of Programming Style : The Unix Hater’s Handbook : The Jargon file : The True Believer : Programming Pearls : The Good Soldier Svejk : The Power Elite

Most popular humor pages:

Manifest of the Softpanorama IT Slacker Society : Ten Commandments of the IT Slackers Society : Computer Humor Collection : BSD Logo Story : The Cuckoo's Egg : IT Slang : C++ Humor : ARE YOU A BBS ADDICT? : The Perl Purity Test : Object oriented programmers of all nations : Financial Humor : Financial Humor Bulletin, 2008 : Financial Humor Bulletin, 2010 : The Most Comprehensive Collection of Editor-related Humor : Programming Language Humor : Goldman Sachs related humor : Greenspan humor : C Humor : Scripting Humor : Real Programmers Humor : Web Humor : GPL-related Humor : OFM Humor : Politically Incorrect Humor : IDS Humor : "Linux Sucks" Humor : Russian Musical Humor : Best Russian Programmer Humor : Microsoft plans to buy Catholic Church : Richard Stallman Related Humor : Admin Humor : Perl-related Humor : Linus Torvalds Related humor : PseudoScience Related Humor : Networking Humor : Shell Humor : Financial Humor Bulletin, 2011 : Financial Humor Bulletin, 2012 : Financial Humor Bulletin, 2013 : Java Humor : Software Engineering Humor : Sun Solaris Related Humor : Education Humor : IBM Humor : Assembler-related Humor : VIM Humor : Computer Viruses Humor : Bright tomorrow is rescheduled to a day after tomorrow : Classic Computer Humor

The Last but not Least Technology is dominated by two types of people: those who understand what they do not manage and those who manage what they do not understand ~Archibald Putt. Ph.D

The statements, views and opinions presented on this web page are those of the author (or referenced source) and are not endorsed by, nor do they necessarily reflect, the opinions of the Softpanorama society. We do not warrant the correctness of the information provided or its fitness for any purpose. The site uses AdSense so you need to be aware of Google privacy policy. You you do not want to be tracked by Google please disable Javascript for this site. This site is perfectly usable without Javascript.

Created May 16, 1997; Last modified: December 26, 2017