LinuxQuestions.org
Did you know LQ has a Linux Hardware Compatibility List?
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Slackware
User Name
Password
Slackware This Forum is for the discussion of Slackware Linux.

Notices



Reply
 
Search this Thread
Old 07-04-2005, 11:58 AM   #1
ToothlessRebel
Member
 
Registered: Jun 2004
Location: FL, USA
Distribution: Slackware 9.1
Posts: 190

Rep: Reputation: 30
Passwords for accounts


There is an account in /etc/passwd by the name mysql. Which is used for (I assume, and I think correctly) mysql administration. I don't know the password. I can su to the account with root of course, but things like PHP-Nuke and the like need that password to access the databases. Or I need to know how to add access to other users.
 
Old 07-04-2005, 12:01 PM   #2
killerbob
Member
 
Registered: Oct 2004
Location: Ottawa, ON
Distribution: Slackware
Posts: 662

Rep: Reputation: 30
It's the MySQL account. It's not used for MySQL administration, it's the username under which MySQLd is run. By default, it's a nondescript password (nothing will work), and it's best that it stays that way.

You administer MySQL with the mysqladm and mysql commands. All of the passwords for MySQL administration are stored in the "Users" database.
 
Old 07-05-2005, 10:33 AM   #3
ToothlessRebel
Member
 
Registered: Jun 2004
Location: FL, USA
Distribution: Slackware 9.1
Posts: 190

Original Poster
Rep: Reputation: 30
OK...

Quote:
1) Create a database called, for example, nuke:

mysqladmin create nuke

2) Now fill the databases with the tables in nuke.sql file:

mysql nuke < nuke.sql
Then I try...

Code:
marshall@toothless:/www$ mysqladmin create nuke
and get...

Code:
mysqladmin: CREATE DATABASE failed; error: 'Access denied for user: '@localhost' to database 'nuke''
I think, "OK, I can use root to create the database."

Quote:
root@toothless:/www# mysqladmin create nuke
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'
root@toothless:/www#


So, what am I screwing up? And can this post get moved to the appropriate forum, because it's no longer a Slackware user names issue?
 
Old 07-05-2005, 10:43 AM   #4
keefaz
Senior Member
 
Registered: Mar 2004
Distribution: Slackware
Posts: 4,617

Rep: Reputation: 136Reputation: 136
You don't have to be root to execute mysql instructions
Mysql's root user is not the same as your system's root
I suggest strongly to read mysql docs and/or download
the GUI tools for easy mysql administration

docs : http://dev.mysql.com/doc/mysql/en/index.html
GUI : http://dev.mysql.com/downloads/administrator/1.0.html

Last edited by keefaz; 07-05-2005 at 10:45 AM.
 
Old 07-05-2005, 02:03 PM   #5
ToothlessRebel
Member
 
Registered: Jun 2004
Location: FL, USA
Distribution: Slackware 9.1
Posts: 190

Original Poster
Rep: Reputation: 30
Will look at both, many thanks.
 
  


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
samba accounts/ unix accounts Buzz88 Linux - Newbie 3 09-25-2005 09:16 AM
qmail -- new accounts can't receive mail, but old accounts can b:z *BSD 1 07-13-2005 01:42 AM
Sync MySQL passwords with local account passwords? turbine216 Linux - Software 2 02-18-2005 04:15 AM
Completely uninstalling MySQL and its passwords passwords...how? I locked myself out! Baix Linux - Newbie 2 01-30-2005 05:10 PM
Is there a way to sync Samba passwords with linux user passwords MarleyGPN Linux - Networking 2 09-09-2003 11:59 AM


All times are GMT -5. The time now is 06:29 PM.

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