store | blogs | forums | twitter | facebook | wiki | downloads | support portal
Atomic Secure Linux
It is currently Sat Oct 19, 2019 6:45 pm

» Feed - Atomicorp

All times are UTC - 5 hours [ DST ]




Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: I need stronger authentication for users then password()
Unread postPosted: Thu May 12, 2016 11:05 am 
Offline
New Forum User
New Forum User

Joined: Thu May 12, 2016 8:45 am
Posts: 2
Location: Hungary
Hi,
I've got authentication problem.
Code:
create user 'uname'@'host' identified by password('secretpass');
works fine, but I want to change password() to another (for example sha2('secretpass', 512).
I have not found solution on google, but some info:
Quote:
mysql uses own password hashing function: password()
I hope that's possible to change it in mariadb.
Are there any solution for that?
Thanks for answers,
cod


Top
 Profile  
Reply with quote  
 Post subject: Re: I need stronger authentication for users then password()
Unread postPosted: Fri May 13, 2016 7:43 am 
Offline
Forum Regular
Forum Regular

Joined: Tue Aug 01, 2006 2:45 pm
Posts: 573
Location: Netherlands
A password is a password. If you need stronger authentication, than use something else (or additionally to the password) as authentication. In any MySQL flavour, also MariaDB, you use password() for password hashing, see https://mariadb.com/kb/en/mariadb/password/.

Protip: firewall your MySQL server.

_________________
Lemonbit Internet Dedicated Server Management


Top
 Profile  
Reply with quote  
 Post subject: Re: I need stronger authentication for users then password()
Unread postPosted: Fri May 13, 2016 10:09 am 
Offline
New Forum User
New Forum User

Joined: Thu May 12, 2016 8:45 am
Posts: 2
Location: Hungary
Thanks.

I've tried to set up ssl for mariadb using a source on net, but failed.
Code:
MariaDB [(none)]> \s
...
SSL: not in use
...
Connection: via unix socket
...
It doesn't matter, but after restart linux I've got an error: "Internal system error."
I've to do something to fix.
If you need info to help, please ask, cause I don't know where can be the problem.


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

» Feed - Atomicorp

All times are UTC - 5 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group