LinuxQuestions.org
Visit the LQ Articles and Editorials section
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices

Reply
 
Search this Thread
Old 04-08-2003, 06:49 PM   #1
Thinkgeekness
Member
 
Registered: Nov 2002
Posts: 81

Rep: Reputation: 15
MySQL questions


Hey, I have mysql4 installed from the binary file, and I am having some problems.

1. When I try to create a password for root I get:
# ./bin/mysql -u root -p

I get the following message:
Error 1045: Access denied for user: 'root@localhost' (Using password: YES)

What is error 1045?

2. How do I create a database?

3. How do I join MySQL and PHP? I am going to use phpBB.

thanks.

Last edited by Thinkgeekness; 04-08-2003 at 06:54 PM.
 
Old 04-08-2003, 07:10 PM   #2
Thinkgeekness
Member
 
Registered: Nov 2002
Posts: 81

Original Poster
Rep: Reputation: 15
Re: MySQL questions

[QUOTE]Originally posted by Thinkgeekness
1. When I try to create a password for root I get:
# ./bin/mysql -u root -p

I get the following message:
Error 1045: Access denied for user: 'root@localhost' (Using password: YES)

What is error 1045?
[QUOTE] Well, I figured out the first one... It was that I didnt have a password. So my question will now be how do I create a password? Also, how do I create a username and password?
 
Old 04-08-2003, 08:36 PM   #3
madcoder
LQ Newbie
 
Registered: Apr 2003
Distribution: RH8
Posts: 8

Rep: Reputation: 0
to change your root mysql password, do the following:

% mysqladmin -u root password <your-desired-password>

that will set the root password,,,

now, to add a new user:

% mysql -u root -p
<type your password>

mysql> GRANT ALL on <databasename or *>.<tables or *> TO <username>@<hostname (try localhost)> IDENTIFIED BY "<password>";

if you want the user to be able to grant other users access, append WITH GRANT OPTION to the end of the last command.

*'s above represent wildcards.
 
Old 04-08-2003, 09:04 PM   #4
Thinkgeekness
Member
 
Registered: Nov 2002
Posts: 81

Original Poster
Rep: Reputation: 15
Thanks! Now I have no more questions about mysql, well, for now.

Thanks again!
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
path and mysql questions Red Squirrel Linux - Newbie 13 03-07-2004 03:16 PM
Mysql - phpMyadmin questions paleogryph Linux - Software 1 02-27-2004 12:47 PM
mysql lot of questions alaios Linux - Software 1 12-12-2003 05:35 PM
A few minor MySQL questions Bigun Linux - Software 11 06-13-2003 01:01 AM
general mysql questions niehls Linux - Software 4 06-17-2002 11:11 AM


All times are GMT -5. The time now is 11:57 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration