Mysql starting problem after changing mysqladmin password.I tried all the solutions available on forums, but not solve the problem.At last I restored the mysql db backup, this make mysql service start, but till other databases not showing all tables.
View 1 RepliesI am not new to linux, but am to mysql. i run a website, on which i decided to put vpet, a virtual pet php thing. now in the instalation of this thing, it did not ask for an admin password. but it did come with a database. so i'm guessing the login is hidden in there. heres the question, i have phpmyadmin. how the heck do i read the database?
View 3 Replies View Relatedi am using liferay5.2(mysql included in the download pack) on fedora. while liferay is working fine but i cannot connect to mysql.i am getting the error
[
[root@localhost ~]# ln -s /var/lib/mysql/mysql.sock /tmp
[root@localhost ~]# /etc/init.d/mysqld start
Timeout error occurred trying to start MySQL Daemon.
[code]....
i didnt find the mysql.sock file in the location /var/lib/mysql/mysql.sock. i cannot find the portal-ext.properties file also to make intial settings.
I think this goes here, but I'm not sure. I decided that XAMPP had been troublesome enough. MySQL never worked. So I decided to instal the LAMP stack offered by YaST. I went about installing it thinking that it would all work. But it seems that I was wrong. So I try to start mysql, and here's what I get:
Code:
the-matrix:~ # mysql start
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) or
Code:
the-matrix:~ # rcmysql start
Starting service MySQL warning: /var/mysql/mysql.sock didn't appear within 30 seconds
chmod: cannot access `/var/run/mysql/mysqld.pid': No such file or directory
[Code]...
Has anyone been able to successfully change MySQL's default datadir in Fedora? I've tried on two machines now (F7 and F11), but run into the same problem on both. Here is what I did:
1. shutdown MySQL (service mysqld stop)
2. create new mysql directory (e.g. ~/mysql/) and set ownership to mysql:mysql
3. move tables from /var/lib/mysql to the new directory (I've tried moving only one user-created table, and also moving system tables with same result).
4. edit my.cnf and change "datadir" to point to new location
5. start MySQL (service mysqld start)
[Code]...
Starting mysqld daemon with databases from /var/lib/mysqli m installed mysql-5.0.77-4.el5_5.4
[root@serv ~]# mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
[root@serv ~]# /etc/init.d/mysqld stop
[code]....
Mysql can't start after I uploaded my.cnf file in /etc directory before that everything was okay but after I uploaded my.cnf and then restarted the mysql it can't boot
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
I tried to delete my.cnf and try again but the same error ...
I'm trying to change the default mysql port with no success. I looked at my.cnf file and there's no reference to port. I also looked at the iptables and mysql is running on 3306 (default).I've changed the iptable file but mysql fails to restart.If I add port = [my port number] to the my.cnf file, mysql fails to start.
View 4 Replies View RelatedI've been attempting to set up a LAMP for local web development, which meant installing mysql-server. But now have a problem when trying to run mysql, I get:-
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
When trying to downgrade mysql-server I saw that there are dependency problems between the various modules (but can't recall which). But whichever route I truied the results are always the same.
Thought about trying XAMPP but I note that even has it's problems, is there any way I can get a lamp set up on FC14, or must I give it up as a bad job.
Howver, just been trying to again to fix the problems with downgrading mysql and get:-
Error: Package: mysql-server-5.1.55-1.fc14.i686 (@updates)
Requires: mysql(x86-32) = 5.1.55-1.fc14
Removing: mysql-5.1.55-1.fc14.i686 (@updates)
mysql(x86-32) = 5.1.55-1.fc14
I have the latest LAMP running on F10 but need to do a database conversion from mysql 4.1.22 to mysql 5 for a client.
View 4 Replies View RelatedI have mysql downloaded and when I type mysql into the command line I get this:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
How do I create a new mysql user and a mysql database at the shell prompt?
View 1 Replies View RelatedI have install mysql on my fedora12. My different mysql server is located in us. I want to check health status and hits per seconds everything. Is it possible with mysql-administrator command.
now a these days i am connect through ssh and excuting below command
#mytop mysql -u root -p <passwd>
In my mysql db i have added the userip & passwd (allowed the privileages for that ip)
If i use mysql-administrator i am getting below error
MySQL Error Nr. 2003
Can't connect to MySQL server on '66.98.152.64' (111)
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]...
Managing MySQL servers can be quite complicated without a proper tool.I have used some commercial tools over the years, but I need something that is Web based, accessible from internet.There are NOT many offerings out there, so I wonder if, beside one company that launched a product quite recently (Novaquantum), there is something else out there that can I can compare it with?I guess when you find something that you like, you'll always to look for something better (PhpMyAdmin doesn't count!)
View 2 Replies View RelatedFirefox & MySQL admin have black line borders. The tab, address input box, the search box, the scroll bars, and the dropdown menu area have this black line border. MySQL's admin utility displays the same. Can't figure out where to change it. Also other thread is about Desktop-Settings utility crashes. Should I just do a restore of user install defaults? How would I do that and save some of my desktop custom program icons?
View 2 Replies View RelatedI did an upgrade install. So, I didn't get the prompt to make one. How to change the admin password? I think I know how I can change my username and password.
View 9 Replies View RelatedHow can I change the root password of MYSQL server. I have just finished installation, but I mistakenly typed the wrong root password, and now I need to change it from command line, because I cannot even access the UI.
View 8 Replies View RelatedI have a server running Mandriva Enterprise Server 5 and have configured apache/mysql/php, the problem i have is that when i reboot the server i have to manualy start mysql. what file i need to configure to enable mysql to start at boot up and what line of code i need to enter to enable this.
View 4 Replies View RelatedAs 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
I consider myself a linux noob. The thing about this is, I have played around with various distros of linux over many years. Eventually I get frustrated at how ridiculous something as simple as text editing can be. I'm having a problem starting mysql. I have already ran the install script afer downloading mysql community server from yast.
what I need to do to start the server. I tried to issue rcmysql start, but it says "The absolute path to 'rcmysql' is 'usr/sbin/rcmysql' so running it may require superuser privileges. So i say SUDO rcmysql, enter password and again same message.
My mysql server won't start on my machine. It simply fails with no errors.
Code:
sudo /etc/init.d/mysql restart
* Stopping MySQL database server mysqld [ OK ]
* Starting MySQL database server mysqld [fail]
When I run cat /var/log/mysql.err the file is empty, thinking this might be a permissions issue
I tried chowning to a mysql user. Here's the current permissions.
Code:
ls -alh /var/log/mysql*
-rw-r----- 1 mysql adm 0 2009-09-30 11:08 /var/log/mysql.err
-rw-r----- 1 mysql adm 0 2010-01-15 09:07 /var/log/mysql.log
-rw-r----- 1 mysql adm 20 2009-11-25 07:35 /var/log/mysql.log.1.gz
-rw-r----- 1 mysql adm 20 2009-11-24 07:59 /var/log/mysql.log.2.gz
-rw-r----- 1 mysql adm 20 2009-11-23 07:56 /var/log/mysql.log.3.gz
-rw-r----- 1 mysql adm 20 2009-11-22 07:54 /var/log/mysql.log.4.gz
-rw-r----- 1 mysql adm 20 2009-11-21 07:47 /var/log/mysql.log.5.gz
-rw-r----- 1 mysql adm 20 2009-11-20 07:43 /var/log/mysql.log.6.gz
-rw-r----- 1 mysql adm 20 2009-11-19 07:35 /var/log/mysql.log.7.gz
/var/log/mysql:
total 8.0K
drwxrwsrwx 2 mysql adm 4.0K 2009-09-30 11:08 .
drwxr-xr-x 16 root root 4.0K 2010-01-15 10:24 ..
Still having the same issue, mysql server is still failing and /var/log/mysql.err is still empty.
I have MySQL installed on my Kubuntu 10.04 desktop machine which I use for developing web applications.First, all worked fine. But then I wanted to synchronize the database with the MySQL database on my laptop, so I had to allow connections from the LAN interface. So I addedCode:bind-address =192.168.0.100to /etc/mysql/my.cnf. This worked and the synchronization was performed. I want to do this on a regular basis so I would like to keep that line in there.The problem now is that MySQL does not start on system boot. When I start up, mysql simply is not started. There are no errors in /var/log/mysql/mysql.err or /var/log/mysql.err; these files remain empty.When I try to start it using 'sudo start mysql' I get the same result. The 'start mysql' shows up in 'ps aux', but the mysql process itself does not.Now, I found out that when I run
Code:
sudo -u mysql mysqld
The mysqld daemon does start, and the server works fine. To make matters even more strange, if I kill this
[code]....
i installed mysql 5.1, the workbench and glassfish along with netbeans for an application I plan to build using the java EE. Glassfish is on local host 8080 and when I installed mysql after that, trying to start mysql from command prompt or even connecting through the workbench gives me error. for example going through the terminal and just typing mysql gives me: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) what should I do so both servers can run at the same time when deploying my application? on windows this is all handled for me. but apparently thats not the case on ubuntu
View 2 Replies View RelatedSo recently my MySQL server doesn't startup when Ubuntu boots (it used to) and therefore causes database errors with my Web applications. How do I add MySQL to the run at startup list?
View 1 Replies View RelatedI had a hard drive failure and have recovered (rsync) my backup root filesystem onto a new drive. This all seems to be fine, except that at least two services no longer start: mysql and apache2.I can start successfully both through
Code:
sudo /etc/init.d/mysql start
sudo /etc/init.d/apache2 start
although mysql throws a warning about Upstart. Neither start automatically.My system is Ubuntu 10.04.1 LTS x86_64. Part of my reolution actions has involved a kernel update to 2.6.32-27-generic.I have tried to resolve the mysql issue first:
Code:
sudo update-rc.d -f mysql remove
sudo update-rc.d mysql defaults
Code:
sudo apt-get remove --purge mysql-server
sudo apt-get install mysql-server
adding them /etc/init.d/... start commands to /etc/init.d/rc.local script and to a session startup script
checking the services are in rcX.d (using bum and sysv-rc-conf) Ensuring there's a .conf file in /etc/init (which there is).I can't see anything in syslog which would suggest if the system has tried to start these but failed, but then I may be looking in the wrong place. I think they're not starting at all. I wonder if it's something to do with the restore, perhaps symlinks?
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.
I recently installed an Ubuntu 10.04LTS server. I have zabbix-server on that machine, and I noticed that after reboot it won't start. Probabily, the mix of upstart and old init.d scripts result in zabbix starting when mysql is not active yet, in fact in zabbix-server.log I see it cannot reach db. How can I make sure zabbix-server waits for mysql?
View 9 Replies View RelatedI have installed Mysql in Ubuntu 9, for the use of roundcube database.After installing iam getting the error like this
* Stopping MySQL database server mysqld [ OK ]
* Starting MySQL database server mysqld [ OK ]
* Checking for corrupt, not cleanly closed and upgrade needing tables.
So because of this in the roundcube configuration its giving the error message that MYSQL is not installed. So Kindly give me a idea how to solve this.
I'm having problems connecting to the mysql database on my system. I first noticed this when I was trying to set up the program anymeal. I subsequently tried using MySQL Administrator (mysql-admin), but had no luck. It gives my the following feedback:
Code:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Click the 'Ping' button to see if there is a networking problem. I press the ping button, and it seems to connect.
Code: