I can't remember the password for mysql anymore; I noted it down the day a did the seafile install but put the note away. So how to get it get back again?

Do have problems with nginx configuration
-
- OMV 2.x
- resolved
- openalf
-
-
mmm not sure on that one, Maybe remove and re-install the MySQL plugin... IF you aren't using MySQL databases on other applications. You will probably need to remove the data from the MySQL-Data folder too.
-
Try this:
Log in as root and stop the mysql daemon. Now lets start up the mysql daemon and skip the grant tables which store the passwords.
sudo /etc/init.d/mysql stop
mysqld_safe --skip-grant-tables
You should see mysqld start up successfully. If not, well you have bigger issues. Now you should be able to connect to mysql without a password.
mysql --user=root mysql
Then restart it normally. You should be good to go. -
-
I can't remember the password for mysql anymore; I noted it down the day a did the seafile install but put the note away. So how to get it get back again?
http://dev.mysql.com/doc/refma…ting-permissions.html</a>to stop mysql use
to start mysql use
-
Well I did uninstall seafile; but before I start the new installation I like to understand if I should create a new folder or should I place it under /root/seafile? I also belive that I don't need to make a new configuration for mysql? What else should I think about before doing the installation. Don't get me wrong I'm not lazy but I feel that I should discuss those steps before I go ahead again.
I do not know how you did the first install of seafile. If you created a seafile user and re going to follow the new guide, you should delete the old seafile user first :
@baldman
And please not: there is a step missing in the new tutorial in part 4 between step 6 and 7:6b restart seafile to make it recognize the new settings
-
-
-
@Zoki, Restarting either Seafile the way you said above or restarting Nginx did not work for me in a fresh new VM. The only thing that worked was to reboot the server. I original had a step there saying to reboot but someone asked me to remove that step saying I was not necessary. For now I will have to put it back in or people will complain about bad gateways. I'll do some more testing later, we might need to restart it another way.
-
-
Did you remove the data from that folder before you reinstalled mysql?... did you reinstall a fresh mysql?
-
-
I deleted the 3 dbase is that good enough?
-
-
Change the:
new-password
to your new password:
really_good_password! -
-
Now I get a syntax error
-
Can you cut&paste the error and command you executed minus the new password?
-
-
-
You need to login to mysql to execute that command. Starting mysql in safe mode allows you to do that with no password. As root,
execute: mysql then enter the update user sql command. Don't forgot the semi-colon at the end. -
Not sure what I do wrong...
root@NAS:~# sudo /etc/init.d/mysql stop
Stopping MySQL database server: mysqld.
root@NAS:~# mysqld_safe --skip-grant-tables
160617 19:34:48 mysqld_safe Logging to syslog.
160617 19:34:48 mysqld_safe Starting mysqld daemon with databases from /media/4fcfda30-31ac-49ad-8d8c-d84723cbe1af/MYSQL-DATA/How do I see that mysql starts automatically
Should I seeroot@nas again or?
-
I think that line is two separate lines.
enter this: UPDATE mysql.user SET Password = PASSWORD('NEW.PASSWORD.HERE')
Then this: WHERE User = 'root'; -
-
Something looks wrong to me:
CodeStopping MySQL database server: mysqld. root@NAS:~# mysqld_safe --skip-grant-tables 160617 20:05:24 mysqld_safe Logging to syslog. 160617 20:05:24 mysqld_safe Starting mysqld daemon with databases from /media/4fcfda30-31ac-49ad-8d8c-d84723cbe1af/MYSQL-DATA/ mysql --user=root mysql update user set Password=PASSWORD('xxxxx9999') where user='root'; flush privileges; sudo /etc/init.d/mysql start
-
I also see that I do have a seafile db file, do I need to delete that one?
Code
Display Moreroot@NAS:~# ls -l insgesamt 62824 -rw-r--r-- 1 root root 26368468 jul 2 2015 CrashPlan_4.3.0_Linux.tgz -rw-r--r-- 1 root root 37926486 sep 30 2015 CrashPlan_4.4.1_Linux.tgz drwxr-xr-x 3 root root 4096 sep 30 2015 crashplan-install drwxr-xr-x 3 1001 plex 4096 aug 22 2015 CrashPlan-install -rw-r--r-- 1 root root 10758 maj 25 22:05 --database=seafile-db drwxr-xr-x 2 root root 4096 jan 24 2015 mnt drwxr-xr-x 2 root root 4096 jan 24 2015 mynas drwxr-xr-x 2 root root 4096 maj 16 11:54 openvpnfiles root@NAS:~#
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!