create specific DB-Admin Account is it possible to create in Mysql an admin-user that can modify everything exept the mysql-root user?

Thanks,
starflighter
Yes It's possible. As per MySQL documentation here
After connecting to the server as root, you can add new accounts. The following example uses CREATE USER and GRANT statements to set up four accounts:

For example

mysql&gt; CREATE USER 'finley'@'localhost' IDENTIFIED BY 'password';
mysql&gt; GRANT ALL PRIVILEGES ON *.* TO 'finley'@'localhost'
    -&gt;     WITH GRANT OPTION;
mysql&gt; CREATE USER 'finley'@'%' IDENTIFIED BY 'password';
mysql&gt; GRANT ALL PRIVILEGES ON *.* TO 'finley'@'%'
    -&gt;     WITH GRANT OPTION;
mysql&gt; CREATE USER 'admin'@'localhost' IDENTIFIED BY 'password';
mysql&gt; GRANT RELOAD,PROCESS ON *.* TO 'admin'@'localhost';
mysql&gt; CREATE USER 'dummy'@'localhost';


The accounts created by those statements have the following properties:


Two accounts have a user name of finley. Both are superuser accounts
with full privileges to do anything. The 'finley'@'localhost'
account can be used only when connecting from the local host. The
'finley'@'%' account uses the '%' wildcard for the host part, so it
can be used to connect from any host.

The 'finley'@'localhost' account is necessary if there is an
anonymous-user account for localhost. Without the
'finley'@'localhost' account, that anonymous-user account takes
precedence when finley connects from the local host and finley is
treated as an anonymous user. The reason for this is that the
anonymous-user account has a more specific Host column value than the
'finley'@'%' account and thus comes earlier in the user table sort
order. (user table sorting is discussed in 
here.)
The 'admin'@'localhost' account can be used only by admin to connect
from the local host. It is granted the RELOAD and PROCESS
administrative privileges. These privileges enable the admin user to
execute the mysqladmin reload, mysqladmin refresh, and mysqladmin
flush-xxx commands, as well as mysqladmin processlist . No privileges
are granted for accessing any databases. You could add such
privileges using GRANT statements.
The 'dummy'@'localhost' account has no password (which is insecure
and not recommended). This account can be used only to connect from
the local host. No privileges are granted. It is assumed that you
will grant specific privileges to the account using GRANT statements.