Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
mysql cant start
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Multimedia
View previous topic :: View next topic  
Author Message
schrdlu
n00b
n00b


Joined: 01 Nov 2009
Posts: 55
Location: Adelaide Sth Australia

PostPosted: Mon May 20, 2013 12:09 pm    Post subject: mysql cant start Reply with quote

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.

* Please provide a password for the mysql 'root' user now, in the
* MYSQL_ROOT_PASSWORD env var or through the /root/.my.cnf file.
* Avoid ["'\_%] characters in the password
>
* Retype the password
>
* 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
* Creating the mysql database and setting proper
* permissions on it ...
* Starting mysqld ...
* 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
............... [ ok ]
* ERROR: dev-db/mysql-5.5.30 failed (config phase):
* 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
*
* Call stack:
* ebuild.sh, line 93: Called pkg_config
* environment, line 3450: Called mysql-v2_pkg_config
* environment, line 3133: Called die
* The specific snippet of code:
* die "Completely failed to start up mysqld with: ${mysqld}";
*
* If you need support, post the output of `emerge --info '=dev-db/mysql-5.5.30'`,
* the complete build log and the output of `emerge -pqv '=dev-db/mysql-5.5.30'`.
* This ebuild is from an overlay named 'gentoo': '/var/db/pkg/'
* The complete build log is located at '/var/tmp/portage/dev-db/mysql-5.5.30/temp/build.log'.
* The ebuild environment file is located at '/var/tmp/portage/dev-db/mysql-5.5.30/temp/environment'.
* Working directory: '/usr/lib64/portage/pym'
* S: '/var/tmp/portage/dev-db/mysql-5.5.30/work/mysql-5.5.30'
Back to top
View user's profile Send private message
DawgG
Guru
Guru


Joined: 17 Sep 2003
Posts: 599

PostPosted: Wed Jun 05, 2013 10:37 am    Post subject: Reply with quote

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
View user's profile Send private message
MONI555
n00b
n00b


Joined: 30 May 2013
Posts: 7

PostPosted: Wed Jun 05, 2013 10:53 am    Post subject: Ho wto restart mysql databases Reply with quote

Hii :lol:

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
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Multimedia All times are GMT
Page 1 of 1

 
Jump to:  
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