View previous topic :: View next topic |
Author |
Message |
schrdlu n00b
Joined: 01 Nov 2009 Posts: 61 Location: Adelaide Sth Australia
|
Posted: Mon May 20, 2013 12:09 pm Post subject: mysql cant start |
|
|
Installed mythtv,but am not able to get mysql to start,have placed it into the default runlevel. mythfrontend setup keeps saying cant connect to server,
and asks for the hostname,it originally was set to localhost but I have since setup my hostname as schrdlu-2,and made the necessary change in the server setup.NOT SUCCESSFUL.
Can someone point me to the relevant help pages,about getting mysql running.
Much appreciated,but really do wish that this wasn't necessary.
Downloaded the setup procedure and attempted to configure,but mysql failed to restart.
[32;01m*[0m Please provide a password for the mysql 'root' user now, in the
[32;01m*[0m MYSQL_ROOT_PASSWORD env var or through the /root/.my.cnf file.
[33;01m*[0m Avoid ["'\_%] characters in the password
>
[32;01m*[0m Retype the password
>
[32;01m*[0m Command: '/usr/share/mysql/scripts/mysql_install_db' '--basedir=/usr' --log-warnings=0 --loose-skip-grant-tables --loose-skip-host-cache --loose-skip-name-resolve --loose-skip-networking --loose-skip-slave-start --loose-skip-innodb --loose-skip-ssl --loose-skip-log-bin --loose-skip-relay-log --loose-skip-slow-query-log --loose-skip-external-locking --loose-skip-log-slave-updates --user=mysql
[32;01m*[0m Creating the mysql database and setting proper
[32;01m*[0m permissions on it ...
[32;01m*[0m Starting mysqld ...
[32;01m*[0m Command //usr/sbin/mysqld --log-warnings=0 --loose-skip-grant-tables --loose-skip-host-cache --loose-skip-name-resolve --loose-skip-networking --loose-skip-slave-start --loose-skip-innodb --loose-skip-ssl --loose-skip-log-bin --loose-skip-relay-log --loose-skip-slow-query-log --loose-skip-external-locking --loose-skip-log-slave-updates --user=mysql --user=mysql --log-warnings=0 --basedir=//usr --datadir=///var/lib/mysql --max_allowed_packet=8M --net_buffer_length=16K --default-storage-engine=MyISAM --socket=//var/run/mysqld/mysqld31562.sock --pid-file=//var/run/mysqld/mysqld23628.pid
...............[A[171C [34;01m[ [32;01mok[34;01m ][0m
[31;01m*[0m ERROR: dev-db/mysql-5.5.30 failed (config phase):
[31;01m*[0m Completely failed to start up mysqld with: //usr/sbin/mysqld --log-warnings=0 --loose-skip-grant-tables --loose-skip-host-cache --loose-skip-name-resolve --loose-skip-networking --loose-skip-slave-start --loose-skip-innodb --loose-skip-ssl --loose-skip-log-bin --loose-skip-relay-log --loose-skip-slow-query-log --loose-skip-external-locking --loose-skip-log-slave-updates --user=mysql --user=mysql --log-warnings=0 --basedir=//usr --datadir=///var/lib/mysql --max_allowed_packet=8M --net_buffer_length=16K --default-storage-engine=MyISAM --socket=//var/run/mysqld/mysqld31562.sock --pid-file=//var/run/mysqld/mysqld23628.pid
[31;01m*[0m
[31;01m*[0m Call stack:
[31;01m*[0m ebuild.sh, line 93: Called pkg_config
[31;01m*[0m environment, line 3450: Called mysql-v2_pkg_config
[31;01m*[0m environment, line 3133: Called die
[31;01m*[0m The specific snippet of code:
[31;01m*[0m die "Completely failed to start up mysqld with: ${mysqld}";
[31;01m*[0m
[31;01m*[0m If you need support, post the output of `emerge --info '=dev-db/mysql-5.5.30'`,
[31;01m*[0m the complete build log and the output of `emerge -pqv '=dev-db/mysql-5.5.30'`.
[31;01m*[0m This ebuild is from an overlay named 'gentoo': '/var/db/pkg/'
[31;01m*[0m The complete build log is located at '/var/tmp/portage/dev-db/mysql-5.5.30/temp/build.log'.
[31;01m*[0m The ebuild environment file is located at '/var/tmp/portage/dev-db/mysql-5.5.30/temp/environment'.
[31;01m*[0m Working directory: '/usr/lib64/portage/pym'
[31;01m*[0m S: '/var/tmp/portage/dev-db/mysql-5.5.30/work/mysql-5.5.30' |
|
Back to top |
|
|
DawgG l33t
Joined: 17 Sep 2003 Posts: 874
|
Posted: Wed Jun 05, 2013 10:37 am Post subject: |
|
|
i think after the installation you have to run
Code: | ebuild <PATH/TO/EBUILD/OF/INSTALLED/MYSQL-VERSION> config | and you will be prompted for the necessary config (like root-pw etc.) them you should check the configs, start the db via its initscript, and then you have to prepare it for mythtv (often there are setup-scripts or instructions included in applications that use dbs).
GOOD LUCK! _________________ DUMM KLICKT GUT. |
|
Back to top |
|
|
MONI555 n00b
Joined: 30 May 2013 Posts: 7
|
Posted: Wed Jun 05, 2013 10:53 am Post subject: Ho wto restart mysql databases |
|
|
Hii
If MySQL is installed as a service (which is most of the time) you can do service MySQLD restart or /etc/init.d/MySQL restart.
You can also use start, stop or reload instead of restart. |
|
Back to top |
|
|
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|