mysqld failed to start
I am trying to start mysqld and it keeps telling me it FAILED. I can't figure out what to do to fix it. This is what it tells me.
Starting mysqld (via systemctl): Job failed. See system logs and 'systemctl status' for details. [FAILED] Can anyone help? Shelly |
Which Linux distribution are you using and how are you trying to start mysqld?
|
I am using Fedora 15 and I am trying to start my SQL using code: sudo service mysqld start and it keeps telling me it failed. I have tried everything.
|
Quote:
Does that include: Code:
Starting mysqld (via systemctl): Job failed. See system logs and 'systemctl status' for details. |
this is what it tells me
[shellyd34@localhost ~]$ sudo service mysqld start Starting mysqld (via systemctl): Job failed. See system logs and 'systemctl status' for details. [FAILED] I also tried this and got this [shellyd34@localhost ~]$ mysql -u root -p Enter password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) |
I also have done this
[shellyd34@localhost ~]$ rpm -q mysql-server mysql-server-5.5.23-1.fc15.i686 [shellyd34@localhost ~]$ /var/log/mysqld.log bash: /var/log/mysqld.log: Permission denied |
s/everything/nothing/g
Please use [CODE]...[/CODE] tags around your pasted info to help make it more readable. Since you still have not looked in the logs, I'll have to guess... my guess would be that you have never initialized the mysql database. See... Code:
man mysql_install_db I am not a Fedora user, but typically you just need to run: Code:
mysql_install_db --user=mysql |
Quote:
|
can you tell me how to use the code tag?
|
When I put in the code this is what it said
Code:
[shellyd34@localhost ~]$ mysql_install_db --user=mysql |
I guess I changed ownership when I did this code
Code:
[shellyd34@localhost ~]$ sudo chown mysql:mysql /var/log/ -chR Code:
changed ownership of `/var/log/ppp' to mysql:mysql |
Quote:
Doing so makes pasted code much more readable and preserves indentation, etc... thanks for trying! |
STOP!
Quote:
That is definitely going to break many things! DO NOT DO ANYTHING ELSE until you get these fixed - and there is not a simple way to fix it because many logs are not owned by root but by their process owners... Why did you do that? |
how can I fix it?
---------- Post added 07-30-15 at 03:31 PM ---------- I did it because I didn't know what I was doing |
Quote:
Is this a production machine or your own learning machine? If a production machine then you will need to quickly find out what user normally owns what logs and change them back individualy, maybe from your backups. Many will be owned by root, but simply resetting all to root will break others and is also a huge security risk in some cases. If you have the install media and another machine or VM to install to, I might suggest doing a quick installation then looking into /var/log to get most of the ownerships. Or if there is another Fedora user here willing to volunteer the ownerships from their system you could reset many that way. If this is a learning machine without much stuff on it, a quick reinstall might be easiest. And be sure to note my own first two rules of troubleshooting: Quote:
|
All times are GMT -5. The time now is 08:52 PM. |