mysql logging error

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

mysql logging error

Roshan
Hello Erman,

we have 1 user dovisadmin. We cannot access mysql using this user. Do you know how we can set this permission?

dovisadmin@dovis-dbsrv1:~$ mysql -u dovisadmin -p
Warning: World-writable config file '/etc/mysql/my.cnf' is ignored
Enter password:
ERROR 1045 (28000): Access denied for user 'dovisadmin'@'localhost' (using password: YES)

Regards,
Roshan
Reply | Threaded
Open this post in threaded view
|

Re: mysql logging error

ErmanArslansOracleBlog
Administrator
It seems like a permission problem.
It is also important the way you give the permission to that user.
For ex: if you connect with "mysql -u dovisadmin -p"  , then you need to
have dovisadmin@localhost.

Read the grant command in the MySQL manual.

2016-05-04 12:22 GMT+03:00 Roshan [via Erman Arslan's Oracle Forum] <
ml-node+s2340467n956h20@n4.nabble.com>:

> Hello Erman,
>
> we have 1 user dovisadmin. We cannot access mysql using this user. Do you
> know how we can set this permission?
>
> dovisadmin@dovis-dbsrv1:~$ mysql -u dovisadmin -p
> Warning: World-writable config file '/etc/mysql/my.cnf' is ignored
> Enter password:
> ERROR 1045 (28000): Access denied for user 'dovisadmin'@'localhost'
> (using password: YES)
>
> Regards,
> Roshan
>
> ------------------------------
> If you reply to this email, your message will be added to the discussion
> below:
>
> http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/mysql-logging-error-tp956.html
> To start a new topic under Database, email
> ml-node+s2340467n4h8@n4.nabble.com
> To unsubscribe from Erman Arslan's Oracle Forum, click here
> <http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=1&code=ZWFyc2xhbkBwYXJ0bmVyYS5jb20udHJ8MXwxODQ5OTg2NjU2>
> .
> NAML
> <http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
>



--

Erman Arslan

Applications and Database Operations Manager


Oracle Certified Expert

Certified Exadata Administrator

Certified Linux Administrator

Author for Apress

MBA


*Blog:*      ermanarslan.blogspot.com

*Forum: * http://ermanarslan.blogspot.com/p/forum.html



M: 05301567803