Administrating the MySQL Server
by
Marc Delisle | February 2012 | MySQL Content Management PHP
In this article wirtten by Marc Delisle, author of Mastering phpMyAdmin 3.4 for Effective MySQL Management, we will discus how a system administrator can use the phpMyAdmin server-management features for day-to-day user account maintenance, server verification, and server protection. The subject of how non-administrators can obtain server information from phpMyAdmin is also covered.
Server administration is mostly done via the Server view, which is accessed via the menu tabs available on phpMyAdmin's home page.
Read Administrating the MySQL Server in fullCustomizing the Menus Menu in Joomla!
by
Hagen Graf | April 2008 | Joomla! MySQL Content Management Open Source PHP
There are numerous menus in the front end of every application. They are often displayed as standalone boxes. The menu items are generally arranged one below the other. Menus can also be integrated into the design horizontally so that at first sight they aren't even recognizable as cohesive menus. CSS menus, which can even be transparent, are very cool.
These menus and the menu links are dynamically administered in Joomla! from database content in the Menus work area. Joomla! has six different menus in the sample data. (main menu, top menu, other menu, user menu, example pages, and key concepts) In this article by Hagen Graf, we will discuss administering, creating and managing menus in Joomla!
Read Customizing the Menus Menu in Joomla! in fullQuestions & Answers with MariaDB's Michael "Monty" Widenius- Founder of MySQL AB
by
| April 2011 | MySQL Open Source Web Development
Michael “Monty” Widenius - Monty was the Main Developer of the MySQL database and the Founder of MySQL AB. Currently he is the CEO of Monty Program, a company founded by him. Monty Program is a center of engineering excellence for a database server called MariaDB, the Aria storage engine, MySQL®, and other associated technologies.
Monty is also a partner in the venture capital company Open Ocean. Monty’s experience and knowledge is highly regarded, which has resulted in many board memberships. He is currently active in the board of IT Mill Ltd, Finsor, Web of Trust by Against Intuition Inc. and several others.
Read Questions & Answers with MariaDB's Michael "Monty" Widenius- Founder of MySQL AB in full
Replication in MySQL Admin
by
Daniel Schneller Udo Schwedt | January 2011 | Cookbooks MySQL
In this article, by Daniel Schneller & Udo Schwedt, author of MySQL Admin Cookbook, we will discuss:
- Setting up automatically updated slaves of a server based on a SQL dump
- Setting up automatically updated slaves of a selection of tables based on a SQL dump
- Setting up automatically updated slaves using data file copy
- Sharing read load across multiple machines
Granting Access in MySQL for Python
by
Albert Lukaszewski, PhD | December 2010 | MySQL Open Source
One needs to tell MySQL what kind of privileges to assign to it. MySQL supports a wide range of privileges. A user can only grant any privilege that they have themselves.
In this article, by Albert Lukaszewski, PhD, author of MySQL for Python, we will cover:
- Granting access in Python
- Removing privileges in MySQL
- Using REVOKE in Python
- Project: Web-based user administration
Getting Up and Running with MySQL for Python
by
Albert Lukaszewski, PhD | December 2010 | MySQL Open Source
There are, several ways to get MySQL for Python in a place such that your local Python installation can use it. Which one you use will depend as much on your familiarity with your operating system and with Python itself, as it will on which operating system and version of Python you are running.
In this article, by Albert Lukaszewski, PhD, author of MySQL for Python, we will cover the following:
- Where you can get MySQL for Python
- Installing MySQL for Python
- Importing the module into your programs
- Accessing online help about the MySQL for Python API and its accompanying modules
- How to connect to a database
- How to create a MySQL cursor proxy within your Python program
- How to close the database connection from Python
- How to access multiple databases within one program
Tips & Tricks on MySQL for Python
by
Albert Lukaszewski, PhD | December 2010 | MySQL Open Source
Python is a dynamic programming language, which is completely enterprise ready, owing largely to the variety of support modules that are available to extend its capabilities. In order to build productive and feature-rich Python applications, we need to use MySQL for Python, a module that provides database support to our applications.
In this article, we will have a look at the tips and tricks presented thru-ought on MySQL for Python.
Read Tips & Tricks on MySQL for Python in fullAdministrating the MySQL Server with phpMyAdmin
by
Marc Delisle | October 2010 | MySQL Open Source PHP
This article, Marc Delisle, author of Mastering phpMyAdmin 3.3.x for Effective MySQL Management, discusses how a system administrator can use the phpMyAdmin server management features for day-to-day user account maintenance, server verification, and server protection. The subject of how non-administrators can obtain server information from phpMyAdmin is also covered. Server administration is mostly done via the Server view, which is accessed via the menu tabs available on phpMyAdmin's home page.
Server administration is mostly done via the Server view, which is accessed via the menu tabs available on phpMyAdmin's home page.
This article specifically covers:
- Managing users and their privileges
- Database information
- Server information
Installing phpMyAdmin
by
Marc Delisle | October 2010 | MySQL Open Source PHP
In this article, by Marc Delisle, author of Mastering phpMyAdmin 3.3.x for Effective MySQL Management, we will cover:
- Installing phpMyAdmin
- Configuring phpMyAdmin
- Upgrading phpMyAdmin
Importing Structure and Data in phpMyAdmin 3.3.x for Effective MySQL Management
by
Marc Delisle | October 2010 | MySQL Open Source PHP
In this article, by Marc Delisle, author of Mastering phpMyAdmin 3.3.x for Effective MySQL Management, we will learn how to import data that we have exported for backup or transfer purposes. Exported data may also come from authors of other applications, and could contain the whole foundation structure of these application along with some sample data.
The current phpMyAdmin version (3.3) can import:
- Files containing MySQL statements (usually having a .sql suffx, but not necessarily so)
- CSV files (comma-separated values, although the separator is not necessaria comma); these files can be imported by phpMyAdmin itself or via the MySQL LOAD DATA INFILE statement, which enables the MySQL Server to handle the data directly rather than having phpMyAdmin parse it frst
- Open Document Spreadsheet files
- Excel files (from versions 97 to 2007)
- XML files (generated by phpMyAdmin)
The binary feld upload can be said to belong to the import family. Future versions might be able to import files in more formats.
Importing and uploading are synonyms in this context.
Read Importing Structure and Data in phpMyAdmin 3.3.x for Effective MySQL Management in full
