Hey everyone, for the past 15 days i’ve been strugling with problems on my droplet since I’ve lost permission rights on my old one and hence decided to create a new droplet. But it seems im still on a dead end with this one.
So the story goes something like this: I tried several times to upload files through FTP and didn’t work, tried to see if there was a problem with the permissions and couldn’t figure that out and then I’ve noticed that the small files (e.g 54bytes ) were sent just fine, so I then tried to increase the limit from 1024 to something 102400 . During that procedure I found out that under /etc/my.cnf did not exist. So I created a modified copy from /usr/share/doc/mysql-server-5.5/examples/my-small.cnf Then I increased the limits from etc/security/limits.conf And also installed nhm in order for the “show” command to be displayed. (Running: show global variables like ‘open%’; ) to verify that the limit was increased.
After this I tried " service mysqld restart " and got an error: unrecognized service.
Then a apache restart: service apache2 restart
Postfix was not set up. Start with cp /usr/share/postfix/main.cf.debian /etc/postfix/main.cf . If you need to make changes, edit /etc/postfix/main.cf (and others) as needed. To view Postfix configuration values, see postconf(1).
After modifying main.cf, be sure to run ‘/etc/init.d/postfix reload’.
Processing triggers for ufw (0.34~rc-0ubuntu2) … Processing triggers for ureadahead (0.100.0-16) … Processing triggers for libc-bin (2.19-0ubuntu6.3) …
So I logged into mysql (mysql -u root -p ) and got a: mysql -u root -p Enter password: ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)
And here is my systems info:
Ubuntu 14.04.1 LTS (GNU/Linux 3.13.0-36-generic x86_64)
System information as of Tue Oct 21 07:10:59 EDT 2014
System load: 0.02 Processes: 86 Usage of /: 9.0% of 29.40GB Users logged in: 0 Memory usage: 21% IP address for eth0: 184.108.40.206 Swap usage: 0%
Any help or thoughts whatsoever please, I’m really confused right now.
Also, some extra info that might help:
ps -eaf | grep -in mysql 85:root 13661 11832 0 08:21 pts/0 00:00:00 grep --color=auto -in mysql
sudo service mysql start start: Job failed to start
service mysql stop stop: Unknown instance:
tail -n 25 /var/log/mysql/error.log 141021 8:24:19 InnoDB: Completed initialization of buffer pool 141021 8:24:19 InnoDB: highest supported file format is Barracuda. 141021 8:24:19 InnoDB: Waiting for the background threads to start 141021 8:24:20 InnoDB: 5.5.38 started; log sequence number 1595685 141021 8:24:20 [Note] Server hostname (bind-address): ‘127.0.0.1’; port: 3306 141021 8:24:20 [Note] - ‘127.0.0.1’ resolves to ‘127.0.0.1’; 141021 8:24:20 [Note] Server socket created on IP: ‘127.0.0.1’. 141021 8:24:20 [ERROR] /usr/sbin/mysqld: Incorrect information in file: ‘./mysql/db.frm’ 141021 8:24:20 [ERROR] Fatal error: Can’t open and lock privilege tables: Incorrect information in file: ‘./mysql/db.frm’ 141021 8:24:21 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 141021 8:24:21 [Note] Plugin ‘FEDERATED’ is disabled. 141021 8:24:21 InnoDB: The InnoDB memory heap is disabled 141021 8:24:21 InnoDB: Mutexes and rw_locks use GCC atomic builtins 141021 8:24:21 InnoDB: Compressed tables use zlib 1.2.8 141021 8:24:21 InnoDB: Using Linux native AIO 141021 8:24:21 InnoDB: Initializing buffer pool, size = 128.0M 141021 8:24:21 InnoDB: Completed initialization of buffer pool 141021 8:24:21 InnoDB: highest supported file format is Barracuda. 141021 8:24:21 InnoDB: Waiting for the background threads to start 141021 8:24:22 InnoDB: 5.5.38 started; log sequence number 1595685 141021 8:24:22 [Note] Server hostname (bind-address): ‘127.0.0.1’; port: 3306 141021 8:24:22 [Note] - ‘127.0.0.1’ resolves to ‘127.0.0.1’; 141021 8:24:22 [Note] Server socket created on IP: ‘127.0.0.1’. 141021 8:24:22 [ERROR] /usr/sbin/mysqld: Incorrect information in file: ‘./mysql/db.frm’ 141021 8:24:22 [ERROR] Fatal error: Can’t open and lock privilege tables: Incorrect information in file: ‘./mysql/db.frm’
Thanks in advance to anyone willing to help !
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.