Showing posts with label add database user. Show all posts
Showing posts with label add database user. Show all posts

Monday, February 02, 2009

Adding a new user to mySQL DB with phpMyAdmin

In addition to the graphical UI provided by phpMyAdmin, you can just issue the following SQL:
GRANT ALL ON DB-NAME.* TO IDENTIFIED BY '';

replace by teh user name you want, e.g. fernandotorres and replace by the password for this user. Note that there are ' signs around the password - keep them.

http://www.trap17.com/index.php/adding-users-databases-using-phpmyadmin_t31803.html

Thursday, January 04, 2007

mySQL 2026 error (SSL connection) on Fedora Core4

In some cases we have got the following error trying to access mySQL DB:

[root@localhost]#mysql
ERROR 2026 (HY000): SSL connection error

This was caused by SeLinux which run on that machine. The simpliest receipt is to switch SeLinux off.

To do that, go to /etc/selinux/config and change the line as follow:
SELINUX=disabled
Than save the file and reboot the system.