MySql user accounts

Dutch_MaFia-boy

Hi,

I am using the Horde application, Kronolith- www.horde.org.....

As well as being tied in with Apache and PHP, it also works with MySql....you have to login to the system, so this I feel is probaly where Mysql comes into play....creating the user login accounts in Mysql....so one can login to the system.....am I right in assuming that...?

My confusion is that I cannot understand the syntax to create the root@localhost account text based..where to add the password, what switches to use....ie) password vs. passwd, where/what direcory to create these user accounts, how to view user accounts....do the <> symbols really apply to the syntax....or just there for help..

Another example of my question is...what does the "$ mysql" part mean...is that the mysql prompt??...mysql> or is thaT just apart of the syntax line runnung it from a prompt with a # sign??

I just need this broken down to make sure I am entering the right information, symbols, ...that I'm interpreting it right...

I am running MySQL Control Center....the GUI for MySQL....i know for a fact that the root@localhost account exists because I can view it through MYSQL CC....through the user administrator...I added a password for the root@localhost account (through Mysql CC)and when I try to run the syntaxes described below...it lists a page or so of switches...kinda like a man page....

The following is a part of a docs page included with Horde/Kronolith..

MySQL

The mysql_create.sql script will create a database called "horde", and a
user called "horde" (with password "horde") that has full rights
to the database.  This script needs to be run as the MySQL root user
(which is NOT the same as the UNIX/Linux root user):

$ mysql --user=root --password=<MySQL-root-passwd> < mysql_create.sql

After running this script, it's a good idea to restart your MySQL
server:

$ mysqladmin --user=root --password=<MySQL-root-passwd> reload

To check that this is working, the following command should connect
without errors:

$ mysql --user=horde --password=horde horde

Type "quit" to quit MySQL.

If you need to uninstall the database, you can do so with:

$ mysql --user=root --password=<MySQL-root-passwd> < mysql_drop.sql

This will delete all your user data!

Thanks..in advance

rinjani

$ mysql is the command line prompt

<= => is to help

your first line should be:

$ mysql --user=root --password=mygreatpassword < mysql_create.sql

the <mysql_create.sql

tells mysql to run this file (which I presume creates a user and db for you)

The use of horde at the end of the line tells mysql that you want to use the horde database.

A standardl way to login to mysql from the command line (as root) is:

$ mysql -u root -p

you then get asked for the password

after verification you usually see:

mysql> meaning that you are now able to do mysql commands such as:

GRANT ALL ON . TO user@localhost IDENTIFIED BY 'some_password';

For more on mysql commands visit the documentation at mysql.com

HTH

Dutch_MaFia-boy

Thanks a lot!! that helped me out ...

I am still having trouble running the script...the mysql_create.sql script is in /var/www/html/horde/scripts/db...

When I enter the MySql server...like you told me..mysql -u root -p...and type :

mysql> < mysql_create.sql.......nothing happens

When I typed help; at the mysql> prompt, I saw that:

source (.) Execute a SQL script file. Takes a file name as an argument.

I tried mapping it to the full path.../var/www/html/horde/script/db....but it still did not apparently work.

When I type . and press enter....it comes back with :
<filename> | source <filename>

I'm not exactly sure what the correct syntax for my case would be...does source refer to the path...../var/www/html/horde/scripts/db..??

rinjani

Normally you have a couple of options to run a script file.

from shell:

$ mysql database_name < path_to_file

or from within mysql (source is the command):

mysql> source path_to_file;

I think you have to have created the user account for root or someone else within mysql before you can run a text file though. The first thing I always do with a new mysql install is create the root password, make a localhost and external host user to own all the databases, then create specific database owners.

Then I run any sql/text files to create tables structures.

HTH

Dutch_MaFia-boy

OK.....so then how do you fo about creating users in MySql.....text based...How can I view the users, their rights and permissions....I have the GUI for MySql...the "MySQL Control Center"...and from what I can see on it...there is a:

1.@dbase (dbase is the name of my server/instance)

@
root@dbase
root@localhost

Can you walk me through it step by step??...creating accounts w/ priveledges..preferably thru the shell..

Both root accounts have global priveledges...The Control Center is nice and everything, but I want to know how to do this through the shell (text) based way....it helps me learn and understand things better....if this is indeed possible....So the root accounts account already exist right...these accounts were created by default...I havcen't tried running the script yet.....I'll let you know how it goes...

Thanks again so much for replying to my post!!

rinjani

I'll show an example but the best way to go about this is reading the manual at mysql.com

From within mysql

mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE on mydatabse.* to user@localhost IDENTIFIED BY 'user_psswd';

This means grant a bunch of privileges to user accessing from localhost on the mydatase and all its tables. User's password is user_psswd.

You can grant a number of different privileges from read only to ALL.

There are two types of user access from localhost or from an external host.

You have to create these seperately:

user@localhost

user@"%"

This should be enough to get most users set up and then for complex permisssions use the manual examples to learn more.

HTH