Solved

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

Posted on 2008-06-13
8
340 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
  • 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
VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

 

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 500 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

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
CentOS 7 Installation 7 72
Error Message during CentOS 7 Minimal Install 3 41
linux redhat 7.2 10 70
maybe no no httpd.conf 6 45
Setting up Secure Ubuntu server on VMware 1.      Insert the Ubuntu Server distribution CD or attach the ISO of the CD which is in the “Datastore”. Note that it is important to install the x64 edition on servers, not the X86 editions. 2.      Power on th…
You ever wonder how to backup Linux system files just like Windows System Restore?  Well you can use Timeshift in Linux to perform those similar action.  This tutorial will show you how to backup your system files and keep regular intervals. Note…
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

813 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now