MySQL Authentication problem

beatstar101 · 2016-06-21T15:46:46+00:00

Hi guys,Have a simple n00b luajit question. Im trying to load a library called libluasocket which is located in:$ ls /home/sviyer/thrift/lib/lua/.libs/liblua...

MySQL Authentication problem

beatstar101

Hello everyone,

I am new to nginx and recently developing a REST API for my server using drizzle module in nginx to connect with MySQL database.

The problem is when I use a user account with no password authentication it works file and return valid result.

but when it use a user with password protection it shows an error access denied.

Password is correct because I have put it in the configuration file myself.

help please.

agentzh

Hello!

On Tue, Jun 21, 2016 at 12:46 AM, jugraj singh wrote:
> I am new to nginx and recently developing a REST API for my server using
> drizzle module in nginx to connect with MySQL database.
>
> The problem is when I use a user account with no password authentication it
> works file and return valid result.
> but when it use a user with password protection it shows an error access
> denied.
> Password is correct because I have put it in the configuration file myself.
>

Please always provide as much details as possible for your "an error
access denied" issue.

Hopefully the following document section helps:

https://github.com/openresty/drizzle-nginx-module#trouble-shooting

Regards,
-agentzh

beatstar101

On Wed, Jun 22, 2016 at 10:08 AM, Yichun Zhang (agentzh)
<age...@gmail.com> wrote:
<snip>
> Hopefully the following document section helps:
>
> https://github.com/openresty/drizzle-nginx-module#trouble-shooting

The following command didn't work:-
"mysql --protocol=tcp -u root --password=mypassword test
Got this error
"mysql: [Warning] Using a password on the command line interface can
be insecure.
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: YES)"

for using this command:-
"mysql --protocol=tcp -u root --password= test"
Got this error
"mysql: [Warning] Using a password on the command line interface can
be insecure.
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: NO)"

but this command  works :-
"mysql --protocol=tcp -u root --password test"
got this thing
"Enter password: "
then it connect to MySQL.

-- 

Jugraj Singh

git :- https://github.com/jugrajsingh
blog :- ezecodes.wordpress.com

"Do not open a door unless you are ready to walk throught it"

beatstar101

On Wed, Jun 22, 2016 at 10:08 AM, Yichun Zhang (agentzh) <age...@gmail.com> wrote:
<snip>
> Hopefully the following document section helps:
>
> https://github.com/openresty/drizzle-nginx-module#trouble-shooting

This my conf file
http://pastebin.com/BBXGfZ7c
I check with "nginx -t" syntax is correct.

Got this error

(2016/06/22 10:42:01 [error] 3954#3954: *1 failed to connect: 23: Access denied for user 'root'@'localhost' (using password: YES) while connecting to drizzle upstream, client: 127.0.0.1, server: , request: "GET /mysql HTTP/1.1", upstream: "drizzle://127.0.0.1:3306", host: "localhost")
--

Jugraj Singh

git :- https://github.com/jugrajsingh
blog :- ezecodes.wordpress.com

"Do not open a door unless you are ready to walk throught it"

agentzh

Hello!

On Tue, Jun 21, 2016 at 10:17 PM, jugraj singh wrote:
>
> This my conf file
> http://pastebin.com/BBXGfZ7c
> I check with "nginx -t" syntax is correct.
>

This is strange. Have you configured "mysql_old_password" in your my.cnf file?

Also try if lua-resty-myqsl works for you:

     https://github.com/openresty/lua-resty-mysql

It's shipped with OpenResty too.

Regards,
-agentzh

beatstar101

On Wed, Jun 22, 2016 at 11:12 AM, Yichun Zhang (agentzh)
<age...@gmail.com> wrote:
<snip>
>
> This is strange. Have you configured "mysql_old_password" in your my.cnf file?
>
Can you explain how to configure "mysql_old_password". Step by Step.

> Also try if lua-resty-myqsl works for you:
>
>      https://github.com/openresty/lua-resty-mysql
>
> It's shipped with OpenResty too.

I does't want to use openresty.
As it does't provide .deb package. Moreover I want to configure nginx myself.
Can you explain the procedure of using lua-resty-mysql with a working example.

-- 

Jugraj Singh

git :- https://github.com/jugrajsingh
blog :- ezecodes.wordpress.com

"Do not open a door unless you are ready to walk through it"

agentzh

Hello!

On Wed, Jun 22, 2016 at 1:27 AM, jugraj singh wrote:
>> This is strange. Have you configured "mysql_old_password" in your my.cnf file?
>>
> Can you explain how to configure "mysql_old_password". Step by Step.
>

You should NOT configure mysql_old_password. If you don't see that
thing in your my.cnf, then you are good.

>> Also try if lua-resty-myqsl works for you:
>>
>>      https://github.com/openresty/lua-resty-mysql
>>
>> It's shipped with OpenResty too.
>
> I does't want to use openresty.
> As it does't provide .deb package. Moreover I want to configure nginx myself.
> Can you explain the procedure of using lua-resty-mysql with a working example.
>

It's documented in the link I give you above. Read the documentation.
The easiest way is to use OpenResty and you can build a .deb package
from it yourself.

Regards,
-agentzh