The FreeBSD Diary

The FreeBSD Diary (TM) Remember
I remember
[ HOME | TOPICS | INDEX | WEB RESOURCES | BOOKS | CONTRIBUTE | SEARCH | FEEDBACK | FAQ | FORUMS ]

FreeBSD Support
 New Topic  |  Go to Top  |  Go to Topic  |  Search  |  Log In   Newer Topic  |  Older Topic 
 mysql user accounts cant connect
Author: namchicken 
Date:   30-03-10 15:33

hi there

i am a serious noob to Freebsd.
i installed mysql server and client.
my database has been created .
it was a dump from a previous server. my issue now is that none of the user accounts login correctly. i have deleted and re-created aswell.

please help . noob calling SOS.

Reply To This Message
 
 Re: mysql user accounts cant connect
Author: Dan 
Date:   12-10-10 10:30

Did you copy over the mysql database? That contains users and login details.

--
Webmaster

Reply To This Message
 
 Re: mysql user accounts cant connect
Author: ddenia 
Date:   26-10-11 13:22

Create a new user and database in Mysql
A short note on the establishment of the command-line mysql new database and new user with full rights to the newly created database.

Login to mysql

# mysql -u root -p

mysql> CREATE DATABASE <имя новой БД> CHARACTER SET utf8 COLLATE utf8_general_ci ;
mysql> GRANT ALL PRIVILEGES ON <имя БД>.* TO 'имя нового юзера'@'localhost' IDENTIFIED BY 'пароль' WITH GRANT OPTION;
mysql> quit;

To look at the settings of an existing database, you must execute the command:

mysql> SHOW CREATE DATABASE <имя БД>;

To change the database using the command use <имя базы>;

http://it-admin.org/os-freebsd/sozdaem-novogo-polzovatelya-i-bazu-v-mysql.html



Reply To This Message
 Forum List  |  Threaded View   Newer Topic  |  Older Topic 


 Forum List  |  Need a Login? Register Here 
 User Login
 User Name:
 Password:
 Remember my login:
   
 Forgot Your Password?
Enter your email address or user name below and a new password will be sent to the email address associated with your profile.
How to get the most out of the forum

phorum.org