Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

default mysql LINUX user (ie named "mysql");

Posted on 2008-06-13
8
Medium Priority
?
359 Views
Last Modified: 2013-12-16
Hi, anyone know the initial password, or how to get it, for the LINUX user named "mysql" (setup by default by mysql on installation).

-or-

a solution in fedora to quickly change owner / group of 98 files.

Problem is, I copied over the data files from my database to this installation. Now owner is "root", and so mysql cant write to them I need to either login as user "mysql" and recopy or batch chown (think thats right command) all the files in that directory. When you change preferences on the folder it does give you the option to change files enclosed, but it is permissions only, not ownership.

Thanks.
0
Comment
Question by:thummper
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
8 Comments
 
LVL 40

Expert Comment

by:omarfarid
ID: 21782723
as root you set the password using

passwd mysql
0
 

Author Comment

by:thummper
ID: 21783086
yes, but if i change it mysql likely wont work (as it will try to use the old password) Im looking for a way to either:

find out what the password is

-or-

batch change owner of all the files in the folder
0
 
LVL 43

Expert Comment

by:ravenpl
ID: 21784472
There's no password at all(but not empty -> login is unavailable) by default for linux user mysql, and You should net set any.
Maybe You asking for default password for mysql's databse root password? It's empty.
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 

Author Comment

by:thummper
ID: 21786050
No, I am not asking for MySQL's root user, LINUX user, named "MySQL". If login is unavailable, then the other solution is needed, a way to change owner on 98 files. ie batch. It does, however, show a 5 digit password by default.
0
 
LVL 43

Expert Comment

by:ravenpl
ID: 21786136
> It does, however, show a 5 digit password by default.
What You mean?

> If login is unavailable, then the other solution is needed, a way to change owner on 98 files
chown -R mysql: /path/to/copied/directory # run as a root
0
 

Author Comment

by:thummper
ID: 21790579
sorry for the delay, been out a bit.

>> It does, however, show a 5 digit password by default.
>What You mean?
if I go (as rot) into the manage user interface it shows an existing password for the user "mysql" and shows the password as ***** (5 digits)

>chown -R mysql: /path/to/copied/directory # run as a root
GREAT! thanks, will this change the owner of the directory only or all files withiin it?
0
 
LVL 43

Accepted Solution

by:
ravenpl earned 2000 total points
ID: 21790962
5 stars means exactly nothing. No one is even able to decode length os the password from it's md5 hash.
Reref /etc/shadow file - the second field is the password. '*' or '!!' means password is locked (unset and not empty)

> chown -R
the '-R' means recursively, dir and anything within.
0
 

Author Comment

by:thummper
ID: 21796270
Sweet. thanks so much.
0

Featured Post

Amazon Web Services EC2 Cheat Sheet

AWS EC2 is a core part of AWS’s cloud platform, allowing users to spin up virtual machines for a variety of tasks; however, EC2’s offerings can be overwhelming. Learn the basics with our new AWS cheat sheet – this time on EC2!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction We as admins face situation where we need to redirect websites to another. This may be required as a part of an upgrade keeping the old URL but website should be served from new URL. This document would brief you on different ways ca…
The purpose of this article is to demonstrate how we can upgrade Python from version 2.7.6 to Python 2.7.10 on the Linux Mint operating system. I am using an Oracle Virtual Box where I have installed Linux Mint operating system version 17.2. Once yo…
Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…
Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.
Suggested Courses

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question