Hello everybody please ignore my noobness,
My problem start from connecting to mysql on ubuntu 12.04
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
and after debugging and googling i found following in error.log,
130714 11:23:45 [Note] Plugin 'FEDERATED' is disabled. ^G/usr/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13) 130714 11:23:45 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 130714 11:23:45 InnoDB: The InnoDB memory heap is disabled 130714 11:23:45 InnoDB: Mutexes and rw_locks use GCC atomic builtins 130714 11:23:45 InnoDB: Compressed tables use zlib 18.104.22.168 ^G/usr/sbin/mysqld: Can't create/write to file '/tmp/ibcN8p9L' (Errcode: 13) 130714 11:23:45 InnoDB: Error: unable to create temporary file; errno: 13 130714 11:23:45 [ERROR] Plugin 'InnoDB' init function returned error. 130714 11:23:45 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 130714 11:23:45 [ERROR] Unknown/unsupported storage engine: InnoDB 130714 11:23:45 [ERROR] Aborting
Here is my some of configurations of
user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp lc-messages-dir = /usr/share/mysql skip-external-locking
Here is my diskspace information which i get by running
Filesystem Size Used Avail Use% Mounted on /dev/vda 20G 2.0G 17G 11% / udev 246M 4.0K 246M 1% /dev tmpfs 100M 200K 99M 1% /run none 5.0M 0 5.0M 0% /run/lock none 248M 0 248M 0% /run/shm
Here is my memory utilization details
total used free shared buffers cached Mem: 495 93 401 0 16 49 -/+ buffers/cache: 28 467 Swap: 0 0 0
When i run
mysql_upgrade (as it says in error details) it gives me
Installing MySQL system tables... Installation of system tables failed! Examine the logs in /var/lib/mysql for more information. You can try to start the mysqld daemon with: shell> /usr/sbin/mysqld --skip-grant & and use the command line tool /usr/bin/mysql to connect to the mysql database and look at the grant tables: shell> /usr/bin/mysql -u root mysql mysql> show tables Try 'mysqld --help' if you have problems with paths. Using --log gives you a log in /var/lib/mysql that may be helpful. Please consult the MySQL manual section 'Problems running mysql_install_db', and the manual section that describes problems on your OS. Another information source are the MySQL email archives available at http://lists.mysql.com/. Please check all of the above before mailing us! And remember, if you do mail us, you MUST use the /usr/scripts/mysqlbug script!
I have googled alot, some says to reboot and then start mysql service, some suggests to re-install mysql but still i am unable to make it correct. Please help me.