1
vote
1answer
637 views

MySQL user created via command line can't access PHPMyAdmin

I'm trying to create a read-only user with access to one database in PHPMyAdmin. Since I'm a server newbie I followed some instructions line-by-line on setting up my database and PHPMyAdmin. As ...
2
votes
1answer
112 views

How can I programmatically grant (and revoke) temporary database access in MySQL?

Suppose I have a datastore comprising many databases. For the purposes of this question, let's assume MySQL, but I suspect it might apply to many technologies. The stored records aren't particularly ...
0
votes
4answers
1k views

Unable to access mysql database remotely

I ran this command- [root@dev-img mysql]# mysql -u root -h 192.168.1.181 -e "use mysql;" and this is the output I got- ERROR 1045 (28000): Access denied for user 'root'@'192.168.1.65' (using ...