Red Hat :: MySQL Cannot Start Except Manually As Root
Aug 16, 2010
I have setup the Red Hat system and installed MySQL through the Add / Remove Program. I have RHEL 5.4.
When MySQL is being started manually it is being started as root. However, when MySQL is being started using the services command it is started as the user MySQL and it doesn't work.
How can I start MySQL service as root? Or is there another way to fix that issue.
Let me know if you need more information (giving details on how to get it would be nice too).
View 13 Replies
ADVERTISEMENT
Apr 14, 2009
I just moved my / from sda1 to an ide drive, hde1. i dont see how this could have caused any of these issues, but it did.
First my network card failed to start. i added a line in my rc.local file (where i put all of my additional programs, etc i want to start):/etc/rc.d/rc.inet1
The above now starts my network card with my static ip configured. dhcpcd also worked but i wanted this static.
Now samba will not start. i have the following line in my rc.local: /etc/rc.d/init.d/samba start
This used to work just fine. at first i thought that samba may be trying to start before my network card gets an ip, but the line is *after* the network startup line. just to make sure, i made an additional script called startsamba which contained a sleep 60 followed by samba start, to delay the startup of samba even further.
The message samba reports is very vague, something like failed - core dumped. most of the core dump log is garbage characters, but here is the beginning which seems like it might contain some info:
Code:
ERROR: Can't log to stdout (-S) unless daemon is in foreground (-F) or interactive (-i) after the system starts, i can drop to a console and type "/etc/rc.d/init.d/samba start" and the service starts just fine. i've also tried starting samba manually with "smbd -d" which also produces the core dump when started from rc.local, but not when started from a console after startup.
View 8 Replies
View Related
Jun 14, 2011
I have tried many different ways to interact with the mysql to reset the root mysql pass. This is what I got to right now
Code:
#!/bin/sh
newpass=$1
service mysqld stop
mysqld_safe --skip-grant-tables --skip-networking &
echo "use mysql;" >> /tmp/mysql_pass_reset.txt
echo "update user set password=PASSWORD("$newpass") where User="root";" >> /tmp/mysql_pass_reset.txt
[Code]...
View 6 Replies
View Related
Apr 29, 2010
As the title states.
Code:
# /etc/init.d/mysql status
Checking for service MySQL: unused
# /etc/init.d/mythbackend status
Checking for service MythTV backend unused
View 9 Replies
View Related
Feb 5, 2009
I thought that the problem is in the phpMyAdmin not in the mysql. But now i think different. It seems that the problem is right in the mysql. I think that there was no root user, when mysql was freshly installed. Unfortunately i did everything i can find on internet (some tutorials) but they don`t helped me at all, maybe i fu**ed up the mysql service. So i reinstalled it, and when i want to start it there is no file mysql.sock and i get the following:
linux-nepg:~ # service mysql restart
Restarting service MySQL
Shutting down service MySQL done
Starting service MySQL warning: /var/lib/mysql/mysql.sock didn't appear within 30 seconds
View 9 Replies
View Related
May 4, 2011
I have a mysql database and i use it with apache for my webpages. And I guess it dosen't start when the computer starts so I have to manually start it with "sudo /etc/init.d/mysql start" This returns fail so i went to '/var/run/mysqld/' and the folder was empty. I don't know if this is the problem or not. How can I fix this?
View 9 Replies
View Related
Mar 15, 2010
I am getting the following error when starting mysql using 'sudo /etc/init.d/mysql start':
Mar 15 16:33:56 MoodFishDev /etc/init.d/mysql[18317]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Mar 15 16:33:56 MoodFishDev /etc/init.d/mysql[18317]: ^G/usr/bin/mysqladmin: connect to
[code]....
View 1 Replies
View Related
Feb 17, 2011
I did a search here & on the web & can't find a "fix" that works. I tried the start order thing & the restart thing & one other I forgot, but nothing works.Funny the RESTART one didn't work as I CAN manually start it OK, unless I didn't put the command in the right spot.I DID notice that there are a few BUGS reported on this but they all go back far enough that I'd think they would be fixed by now.I don't have to manually start this thing every time I want to use it?
View 14 Replies
View Related
Mar 5, 2010
I just installed eclipse 3.5 manually from the eclipse website and installed it into my /opt directory.
View 2 Replies
View Related
Jun 21, 2010
When I first installed Lynx it would boot fine but as the first kernel updates came in it began to get really dodgy. Some days a certain kernel would boot up fine whereas the other would boot without X (i have dual boot with XP and so the kernel options come up on GRUB)Just today I updated the NVIDIA drivers and now neither boots fine, I looked around and I found that after logging in running "startx" in the CLI, which is displayed instead, i get my normal desktop back again.
View 2 Replies
View Related
Mar 10, 2010
I'm just trying to install Ubuntu server 9.10 to a logical volume manager partition. I have two physical disks of 250GB - each has a 10GB primary partition and 240GB logical partition for LVM
I created partions using 'manual partitioning'.
It shows:
LVM VG grpA 240GB
LVM VG grpB 240GB
SCSI1 (sda) 250GB
#5 logical 240GB K lvm
[Code].....
I want '/' (i.e root) to be on a logical volume in the lvm 'grpA' (on disk sda).
But the installer does not offer creation of Logical Volumes or their format - only seems to go as low as volume group. If I try continuing installer complains that 'no root file system is defined'.
Does anyone know how I create the LV and install with root there?
(On another machine with 9.04 I used the guided partitioning with use entire disk and lvm - that just worked putting root in the lvm... but this current machine needs a specific layout).
View 4 Replies
View Related
May 19, 2010
If you manually partition Ubuntu Linux; how much do you allot to your root directory? If someone installs many games and software, should they use a very large root directory such as 30GB or more?
View 6 Replies
View Related
Feb 24, 2010
Long-time linux user, new to Ubuntu (mainly a gentoo user). I need to get tor and privoxy up and running for a less computer-capable user. I installed Tor and Privoxy, configured them (apparently correctly) and they both appear to work just fine when I start them manually from their init scripts:
sudo /etc/init.d/tor start
sudo /etc/init.d/privoxy start
However, I cannot seem to get privoxy to start up properly when the machine boots. Tor starts up and waits patiently, but privoxy is dying or getting killed for some reason I can't understand, and on Ubuntu, have no idea how to diagnose. There's no privoxy process after booting, and the init.d script reports status: not running. I have the startup scripts for both Tor and Privoxy linked to in all the relevant runlevels. I played with the order thinking it might be a dependency thing. Hell, I even put a line in rc.local to try and force it to go. But no matter what I do, I can't seem to get the privoxy service to start for me any way but by manually typing 'sudo /etc/init.d/privoxy start' in a terminal, after logging in.
1. Help me get privoxy to auto-start during init
2. OR Help me figure out how to figure out how to get privoxy to auto-start during init. On Gentoo, all of the init scripts are listed on the screen during init as they run, and you can even run through them interactively by pressing I during startup. I have no idea how to do this on Ubuntu. I modified the kernel line to remove the splash screen, but the information Ubuntu puts on the screen during init is quite haphazard. How do I figure out what's going wrong with the privoxy init script?
View 1 Replies
View Related
Mar 11, 2011
I have Thunderbird setup with the minimize to tray add on. I have it setup to start on boot but I would like it to start and then minimize to the system tray without me having to manually minimize it. I just can't figure it out. I have mounted a windows share with smbfs and it is in the fstab file but when the computer boots I have to type in terminal
[code]...
then terminal asks me for root password and then another box comes up after that that just says password. In the second password box it doesnt matter what you type in it will still mount. Even leaving it blank mounts. I read in some other threads about editing rc.local and also visudo. Neither one of those fixed it. I also made a script to run the above command and then added it to system>preferences>startup applications. That didn't work either.
View 6 Replies
View Related
Feb 21, 2015
I'm trying to manually boot (from the GRUB console) into a system set up as follows: crypt partition -> LVM -> root LV, and I'm having some trouble figuring out how to do this from the GRUB console.
I have successfully manually booted a system which is set up as just LVM -> VG -> root LV. All I have to do is load the LVM module. In GRUB, that partition shows up as (hd0,gpt5). Once I load the GRUB LVM module, I can see the logical volume within the LVM as well. (My volume group name is "caesar", and the single logical volume is named "root".)
Code: Select allgrub> ls
... (hd0,gpt5) ...
grub> insmod lvm
grub> ls
... (lvm/caesar-root) ...
It's fairly simple to manually boot:
Code: Select allgrub> set root=(lvm/caesar-root)
grub> linux /vmlinuz root=/dev/mapper/caesar-root
grub> initrd /initrd.img
grub> boot
Where I am having difficulty is in trying to insert crypt before LVM. I can set up such a scheme, and put a minimal installation on it, without issues. It's booting into it upon reboot that I can't figure out. Once I load the GRUB crypto, cryptodisk and luks modules, I can mount the crypto partition:
Code: Select allgrub> ls
... (hd0,gpt5) ...
grub> insmod crypto
grub> insmod cryptodisk
grub> insmod luks
grub> cryptomount (hd0,gpt5)
Attempting to decrypt master key...
Enter passphrase for hd0,gpt5 (<long hex string here>): <type my password>
Slot 0 opened
grub> ls
... (crypto0) ...
At this point, GRUB sees the crypto partition as (crypto0). But the GRUB LVM module doesn't see "inside" of the crypto partition, so I don't see the root logical volume within the LVM listed; all I see is (crypto0).
Code: Select allgrub> insmod lvm
grub> ls
... (crypt0) ...
Setting it as root doesn't work:
Code: Select allgrub> set root=(crypto0)
grub> ls /
error: disk `crypto0' not found.
So, How do I get GRUB to "see" LVM inside the crypto partition?
View 0 Replies
View Related
Jul 28, 2009
I am trying to get mysql to start at boot without any success.
The mysqld scripts works fine when run from the command line, but it does not work when i use the links created by chkconfig. I checked the boot.log and found that mysql starts but then it stops or gets shutdown. This is the log message:
Starting mysqld daemon with databases from /data/mysql [ OK ]
Starting cups: [ OK ]
STOPPING server from pid file /var/run/mysqld/mysqld.pid
starting DenyHosts: /usr/bin/denyhosts.py --daemon --config=/usr/share/denyho
sts/denyhosts.cfg
090727 04:35:47 mysqld ended
The same init script works fine in Ubuntu.
View 2 Replies
View Related
Feb 15, 2011
I've been playing around with various distributions including Arch Linux, openSuse, and Ubuntu with it's derivatives. So far, I feel that Ubuntu flows the best out of them all, offering the best mix of user-friendliness, eye-candy, and performance. HOWEVER, I really like doing things from the ground up and like having complete control over what I am using/spending resources on. OpenSuse was very attractive to me because of it's [URL]... which allows you to start with a basic system and add, manually, each and every package you want so you get exactly what you want. Does Ubuntu offer any system like this? Or, alternately, is there a "barebone" download in which you get basically a command line with networking and can apt-get all of the packages you want?
View 9 Replies
View Related
Nov 3, 2010
I'm trying to figure out how to operate a rather large Java program, 'prog'. If I go to its /bin/ dir and configure its setenv.sh and prog.sh to use local directories and my current user account. Then I try to run it via "./prog.sh start". Here are all the relevant bits of prog.sh:
[code]...
When I actually do ./prog.sh start, it starts. But I can't find it at all on the process list. Nor can I kill it manually, using the same command the shell script uses. But I can tell it's running, because if I do ./prog.sh stop, it stops (and some temporary files elsewhere clean themselves out).
[code]...
the process is running yet not in any way listed by the system. I can't find it in ps or /proc/, nor can I kill it. But the shell script can still stop it properly. So my question is, how can something like this happen? Is the process supremely hidden, actually unlisted, or am I just missing it in some fashion? I'm trying to figure out what makes this program tick.
View 2 Replies
View Related
Apr 11, 2011
I installed MySQL and I started playing around (first time using a database).
I eventually ended up deleting the root user. And now I can't log back in.
I tried
Code:
And I was prompted to set a new root password, which I did. However...
Code:
I want to do a fresh install of MySQL.
View 2 Replies
View Related
Feb 8, 2010
I cannot see what the problem is here. I have installed MySQL 5.1.36 via YaST on my openSUSE 11.2 (32-bit) system.I can log in as root. I can "create user MY_user identified by 'my_passwd';" and a new user is created. But I cannot log in to the database using that new user name. I keep getting the message:
Code:
> mysql -b -u MY_user -p
Enter password:
[code]....
View 6 Replies
View Related
Jan 11, 2010
I went away this weekend and everything with my mysql server was working great. I got home on sunday, and I found that my web pages couldn't be displayed because they were unable to gain access to the mysql database.
I am now not able to log into mysql using root or debian-sys-maint. I get error messages.
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
I have tried loading mysql in safe mode, and changing the passwords, but this does little to help me.
I am unable to retart my services without them failing, so after making the changes i have to manually kill the processes for mysql to get it to stop. After doing that i try to start mysql up, and it gives me a .sock error. I will post some of the errors in my next post, but if anyone has a general idea what i can try to manually override the passwords or reset them. I did read that i can reset the debian-sys-maint password using the msql/rm.conf , but i am unable to log on as root to change the password
View 2 Replies
View Related
Dec 11, 2010
I'm running an Ubuntu 9.04 Minimal server and trying to get MySQL to work correctly. But when I try to access MySQL with the root user it doesn't want to.
Code:
mysql -u root -p
Enter password:
[code]....
View 4 Replies
View Related
Jan 4, 2011
I am using Ubuntu 10.04.1 LTS x64. I would like to backup my /var/lib/mysql directory as a non-root user.
I have been backing this up using cron as the root user, but another admin in my company insists that we create a separate user to perform this task for security reasons. I have created a user, created a group, added the user to the group, but still cannot access /var/lib/mysql/mysql directory as that user. I would like that user to have +rx access only.
View 5 Replies
View Related
Sep 21, 2010
for resetting the root user's password. Actually, I am using www.linuxzoo.net for online practice of Linux and have MySQL installed on it. But I forgot the password I set. There was no password by default set for the root user. So, I just trying setting a password last week. Now I am not getting what I did.
View 13 Replies
View Related
Aug 9, 2010
I have a question in regards to enabling root remote access to the server.I am trying to use the mysql workbenchit kicks back an error saying "Access denied for user 'root'@'10.x.x.x' (using password: YES)" But I am able to login locally on the server.How do I enable root to long on remotely from any workstation?
View 3 Replies
View Related
Aug 1, 2010
Following guide for CentOS 5.5 i've installed mysql server on my box.Next step was setting up password for root user.As you undestood, it failed. output:
Code:
# rpm -qa | grep mysql
mysql-devel-5.0.77-4.el5_5.3
[code]....
View 1 Replies
View Related
May 28, 2010
is there any way to remove the root password in mysql,if can what is the command to remove it.
View 3 Replies
View Related
Dec 2, 2009
I've installed mysql server and starting it "service mysqld start"
I get:
Here is what get in "mysql.log"
View 2 Replies
View Related
Jul 15, 2010
I installed MySQL 5 on Fedora Core 13 guest on Win Vista host. After I ran the bash script to install it:
Code:
groupadd mysql
useradd -g mysql
tar -xvf mysql-5.1.48.tar.gz
cd mysql-5.1.48
CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3 -felide-constructors
-fno-exceptions -fno-rtti"
./configure --prefix=/usr/local/mysql --with-mysql-ldflags=all-static --with-charset=utf8
make test
make
I ran the mysql but I received the error 2002 so I changed the my.cnf with medium.cnf, pointed in the file the path to the mysql.sock file and tried changing the owner of mysql.sock to the user mysql. It didn't work so in the end I gave 777 permissions (755 didn't work either). Now the error reporting when starting mysql is
Code:
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111).
View 4 Replies
View Related
May 3, 2010
I have had tons of issues with the linux today. Now when I try and start mysql it just fails. the syslog says:
May 3 16:19:40 tp-inventory /etc/init.d/mysql[7783]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
May 3 16:19:40 tp-inventory /etc/init.d/mysql[7783]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
[Code]....
View 6 Replies
View Related
