469,621 Members | 1,688 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,621 developers. It's quick & easy.

Postgres to Mysql administration

Postgres to Mysql
I've administrated a few Postgres database servers in the past, but
have just started working with mysql, as I've volunteered to admin the
mysql server run by my school's comp sci student organization. I'm
going through the mysql manual on the mysql website right now,
starting to figure out the differences and similarities between the
systems. It seems like security and user administration is handled a
bit differently between the two, but how exactly isn't clear to me
yet.

Having fooled around with it a bit more, I've found that it looks like
there is one server running, and that it has a number of databases
running on it. It looks like there is one main listing of users, which
is kept in the mysql database. From what I understand, each user is
linked to a particular host, or network location where they login
from. I've installed everything on my debian stable system, and it
looks like it's added a few extra users. I was expecting just the root
user, but when running the following command, I got:

mysql> select host, user from user;
+-----------+------------------+
| host | user |
+-----------+------------------+
| cthulhu | |
| cthulhu | root |
| localhost | |
| localhost | debian-sys-maint |
| localhost | root |
+-----------+------------------+
5 rows in set (0.00 sec)

I assume I should remove a few of these?

Anyway, I was just wondering if anyone had any advice for one moving
from Postgres to Mysql administration.

Cheers!
Jul 19 '05 #1
0 1607

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

12 posts views Thread by OneSolution | last post: by
6 posts views Thread by Th3L0rD | last post: by
8 posts views Thread by wlcna | last post: by
3 posts views Thread by Gaetano Mendola | last post: by
11 posts views Thread by Mark Cubitt | last post: by
3 posts views Thread by warwick.poole | last post: by
6 posts views Thread by Prabu Subroto | last post: by
7 posts views Thread by Randy Yates | last post: by
3 posts views Thread by fjm67 | last post: by
reply views Thread by devrayhaan | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.