AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Untar in linux mint1/9/2023 If you want the user to connect from any other host you must issue GRANT statements for both and (“%” means any host name).ĭo not give normal users read access to the tables in the mysql database. Mysql> GRANT ALL ON database_name.* TO BY ‘utahep’ If you want to grant full privileges (create, drop, grant, select, insert, update, delete, index, alter, etc.) to the user on the database: This means that you created a user ‘utahep’ who can connect with a password ‘utahep’ from the localhost having only read privileges (means selective privileges) on the database which is ‘database_name’. Mysql> GRANT SELECT ON database_name.* TO BY ‘utahep’ Mysql> GRANT USAGE ON database_name.* TO BY ‘utahep’ Now you can create user accounts (as administrator): You can connect to MySQL as root (administrator), even from another host. MySQL commands should be followed by a semicolon. Mysql> SET PASSWORD FOR root=PASSWORD(‘new_password’) Since anything created in the test database can be removed by anyone else with access to it, it is always good idea to set up a root (administrator) password and open user accounts and grant privileges to users. When you install MySQL database, a test database is automatically created that any user has the all privileges on it to try things out. It is required because it stores all the information about user access privileges. Once you install MySQL, the safe_mysqld script in /usr/bin directory starts the server with mysqld daemon and the mysql_install_db script in the same directory creates six tables (user, db, host, table_priv, colums_priv and func) in the mysql database which is controlled by the administrator. The RPM also creates the appropriate entries in ‘/etc/rc.d’ to start the server automatically at boot time. To perform the installation, run (as root): To see all the files in an RPM package, run: They will appear in your local directory as Download both Server and Client programs rpm files. The recommended way to install MySQL on Linux is by using an RPM (RetHat Package Manager) file. Go to downloads and Linux downloads links. I describe here how to install MySQL 3.23 (stable release, recommended) on Linux. Go to the page to see which platforms are supported and to decide which version and type of distribution to use. The most recent version of the MySQL reference manual is available at Where to learn more: The MySQL home page,, provides the latest information about MySQL. Requirements: MySQL needs at least Linux kernel versions 2.0 or higher. Since the core of the Magda- Manager for Grid-based Data is a MySQL database (the principal entities of Magda are implemented as MySQL tables), we wanted to install MySQL first to better understand its functionality and features. It is provided by MySQL AB, a Swedish company owned and run by the MySQL founders and main developers. It is a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. Introduction: MySQL is a relational database management system. Abstract: I explain how I installed MySQL database on my machine and the web-interfece of MySQL (phpMyAdmin, running on ).
0 Comments
Read More
Leave a Reply. |