The users tag has no wiki summary.
9
votes
3answers
5k views
Access denied for user 'root'@'%'
I used to access the root user in MySQL just fine. But recently, I am no longer able to.
I am able to login fine :
mysql -u root -p
Here is the mysql status after login :
mysql> status
...
8
votes
5answers
2k views
How to manage millions of users?
I am about to launch something really big. I need to prepare my server and database.
I would like to group each set of 100,000 users in separate user tables but I do not know how to associate one ...
5
votes
2answers
647 views
Difference between database vs user vs schema
I'm really confused with the terms database, user and schema. Can anyone explain how they are different from each other (if they are)?
If they are same then, what are the similarities between them? ...
3
votes
1answer
65 views
Why is this user “Admin” created in all databases?
When I create database in SQL server Management Studio, user with name "admin" is also created for all databases:
Why this user is created? And how I can change this behavior?
2
votes
1answer
2k views
How do I automatically grant all privileges to a schema created by a user in mysql?
Someone new joined the company and I created an account for her in mysql using the following:
CREATE USER 'username' IDENTIFIED BY 'password'
She needs to create her own schema and so used:
GRANT ...
2
votes
1answer
2k views
MySQL user permission on stored procedure
I've created a simple stored procedure:
mysql> CREATE FUNCTION hello (s CHAR(20))
-> RETURNS CHAR(50) DETERMINISTIC
-> RETURN CONCAT('Hello, ',s,'!');
Query OK, 0 rows affected, 1 ...
2
votes
0answers
45 views
How can I copy a user while preserving all privs?
We're changing domains. I'd like to create a new account for myself, NewDomain\Bob which has the same su-level privileges as OldDomain\Bob, to minimize the chance of disruption when IT flips the ...
1
vote
1answer
47 views
How are these two user drops different?
Other than the obvious, what is the difference between:
drop user user_01@host01;
and
drop user 'user_01'@'host01';
In a sample test, they both achieved the same result. From Account Names docs ...
1
vote
1answer
68 views
How to allow a user to create databases only with a certain prefix?
We're having a multi-user Linux server. I'd like to give each user the ability to create and manage databases at will, but to keep things sane, force them that each database name they create must ...
1
vote
2answers
113 views
MySQL export user with semi-colon “;” on the end
I am trying to set up automatic export of user accounts from one server to import into another. I am running the following command;
$ mysql -u root -p -B -s -e "show grants for 'myuser'@'localhost';" ...
1
vote
1answer
34 views
How to get user-specific settings in PostgreSQL?
I have to collect some information of PostgreSQL roles. One piece of information is whether the role has different settings than 'usual', usual meaning here default values for only a few parameters ...
1
vote
1answer
72 views
Limiting user access to tables based on a ROLE
I have a SQL Server 2005 database to which I would like to LIMIT access. I have done the following:
Created a database role called NO_HR
Added the tables to this role under Securables that should be ...
0
votes
1answer
214 views
How to find which tables and views a user has access to?
We have a SQL Server 2008 database and have restricted all tables and views away from a specific user ID. Over the years we have granted back tables and views one at a time based on user need.
We ...
0
votes
1answer
203 views
Adding a user to MySQL with 'name'@'%' fails with ERROR 1396
I just tried to add a new user to MySQL using
CREATE USER 'name'@'%' IDENTIFIED BY '...'
However, it fails with the following error:
ERROR 1396 (HY000): Operation CREATE USER failed for ...
0
votes
1answer
31 views
Add user to sql server with the required permission
In my sql server express 2008 r2 i have about 15 login account. Now i want some about 5 users have full permission while some other 5 users with limited access to some database, and other users only ...
0
votes
2answers
21 views
Mysql slow.log user specific
I use a slow.log logging on my MySQL server, to catch bottlenecks in my script, but at the same time, i use phpmyadmin on this server. My script and pma has different MySQL user accounts and now, when ...
-1
votes
0answers
26 views
MongoDB Schema for Users and Admin
I'm new to schema design in MongoDB.
The web app allow users to create their account and login with their email address and password.
Also, there is an admin dashboard of the web app which can be ...
