13
votes
3answers
557 views

Which MySQL users are necessary?

My MySQL server has a number of strange users which I did not add. Are these all necessary? 'root'@'127.0.0.1' 'root'@'localhost' 'root'@'SERVERNAME' 'root'@'::1' ''@'SERVERNAME' ''@'LOCALHOST' If ...
1
vote
0answers
243 views

Error when using mysql to create or change users

I went to change passwword on my mysql user to make sure it was correct for wordpress and when i did it i got Failed to save user : SQL flush privileges failed : Table 'mysql.servers' doesn't exist so ...
-2
votes
1answer
131 views

mysql.user table corrupt even after re-install

I recently corrupted the mysql.user table in my mysql install on centos 5.6, so I removed the mysql and mysql-server packages and then removed /var/lib/mysql. Then, I re-installed mysql and ...
0
votes
2answers
1k views

Root users and mysql: `sudo mysql` vs `/root/.my.cnf`

I have a /root/.my.cnf file which stores the mysql root user's password: [client] password = "my password" When I log in as system root and enter mysql, I get a passwordless login: myuser@local:$ ...
0
votes
3answers
37k views

How do I grant full permissions to a user with mysql?

How do I grant full permissions to a mysql user? Im running MySQL 5.1 on Redhat. I tried using cpanel, but when I use jet profiler it says I do not have full permissions. I am not too good with ssh, ...
2
votes
2answers
190 views

How can I consolidate multiple MySQL servers? [duplicate]

Possible Duplicate: How to copy user priviledges with MySQL? I recently migrated a bunch of under utilized physical servers to one powerful server running Xenserver. I then turned one ...
1
vote
2answers
154 views

Giving user exact amount of MySQL databases

If I wanted to grant user 'abc' to create exact amount of databases ( for example 10 ) how would I do this ? Or anything similar maybe?
15
votes
2answers
43k views

How can I show user's privileges in MySQL?

I know that I can set user's privileges in the following simple way: grant all on [database name].[table name] to [user name]@[host name]; But how can I see existing privileges? I need to see data ...
0
votes
2answers
236 views

Re-assign host access permission to MySQL user

I have several thousand MySQL users all set to allow access from a specific host. The problem is that now I'm going to have two machines (more in the future) which will need to use the same account to ...
0
votes
3answers
300 views

How do I get MySQL to run at startup under user `mysql`?

I'm using MySQL on CentOS and I want it to run at startup under the mysql user. I tried /sbin/chkconfig --level 35 mysqld on from my cool-RR user, but it seems like this makes mysql try to run as ...
0
votes
6answers
4k views

Cannot log in with created user in mysql

Using this command GRANT ALL PRIVILEGES ON *.* to brian@'%' identified by 'password'; I try to login with: mysql -u brian -ppassword The error is: ERROR 1045 (28000): Access denied for user ...