Gentoo mysql gui tools

This will create a database, set proper permissions on the database, and assist in creating a good root password this is for the MySQL root account, which is not related to the Linux root account.

When the database is up and running, connect to it using the mysql client application. From this point, a session to the MySQL instance is open, allowing for queries and administrative commands to be serviced.

To remove old databases and start fresh, this directory can be renamed or removed so that a new database can be created. This page contains changes which are not marked for translation. Other languages:. Let's take a quick look at the first form. It's relatively simple and gives you an overall look of your table. We'll go ahead and run it to see what data we have so far. Now, let's say that we just want to see the record for Chris White.

We can do so with the second form of select as shown below. As expected, the specific entry that we were looking for has been selected. Now, let's say we only wanted to know the person's job and email address, not their name. This method of selection is a lot easier to manage, especially with larger amounts of information, as we'll see later on. Right now, being the root mysql user, we have unlimited permissions to do what we wish with the MySQL database. In a server environment, a user with such privileges can be quite problematic.

In order to control who does what with the databases, we setup privileges. Privileges are what kind of access users have to databases, tables, pretty much anything. Right now in the gentoo database, the MySQL root account is the only account that can access it, given its permissions. Now, let's create two somewhat generic users, guest and admin, who will access the gentoo database and work with the information in it.

The guest account will be a restricted one. All it will be able to do is get information from the database, and that's it. In most cases, this will be localhost. To create our users for this example:.

First we have the privileges we wish to assign. With what we've learned so far, here are some of the privileges you can set:. For our admin user, ALL will do. In this example, gentoo is the database. If you wanted to, you could apply per table access. Now that we have the users setup, let's test them out. First we quit mysql by typing quit at the command prompt:. We're now back at the console. Now that we have our users setup, let's go ahead and see what they can do.

We shall now attempt to login as the guest user. This basically comes down to being able to search and nothing more. Go ahead and login with the guest account. As you can see, this function fails, as our user does not have the appropriate access. Let's go ahead and try that:. The command succeeds, and we're given a glimpse of what user permissions can do. We did, however, create an admin account as well. This was created to show that even all permissions granted users can still have limitations.

Go ahead and quit MySQL and login as the admin. To begin, we'll try creating a new database with our admin user. This admin user will have access similiar to the root MySQL account, and will be able to do any kind of modification to the gentoo database it chooses. This will test the user's access to the main MySQL database. Remember ealier that we only set permissions to a specific database. Indeed, the admin user cannot create databases on the main MySQL database, despite all his permissions on the gentoo database.

However, we're still able to use the admin account to modify the gentoo database, as shown here by this example data insertion.

The admin user can access the database as they please. Now sometimes, we need to get rid of user permissions. This could be anything from a problematic user to a retired employee. We can either deny full access, or specific access.

In this section however, we're going to deny full access to a user. Let's say we find out the guest account is causing some problems security wise. We decide to revoke all privileges. We login as root and do the needful. Golden UTC. Comment 13 Dan UTC. Comment 31 bschnzl UTC. Comment 35 Kevin UTC. Comment 38 Bakus UTC. Current packages show other bugs. High normal vote. Show dependency tree. Reported: UTC by gapon. Attachments Add an attachment proposed patch, testcase, etc.

Call stack: ebuild.