I an running a script Database backup script in my server.It is thworing error ,i have checked permissions for root@localhost , root has all privileges.
### MySQL Server Login Info ###
MUSER="user"
MPASS="password"
MHOST="localhost"
[code]....
and it is throwing error
mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect
mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect
mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect
mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect
I have two hard disks, the one that I work with and another one for backups. The main HD had an OS (Ubuntu) partition, a partition for /home and a lot of free space.I installed latest Mandriva creating a new partition. Everything OK. But it overwrote GRUB and I couldn't boot into Ubuntu, so I reinstalled GRUB from the Ubuntu live CD. I got my Ubuntu back, but then it wouldn't boot into Mandriva. Well, I didn't care. But now the problem comes.
Right now, if I try to install Ubuntu from live CD, the installer won't see the partitions in my main drive. It sees the partitions in the backup drive, but the main drive appears as empty, no Ubuntu, no Mandriva, and no /home. Debian testing installer did just the same. Those partitions are there and I can boot into them and see them; it's only the installer that does not see them.
If I click the network indicator and select Connection Information, I get a dialog that says "Error displaying connection information: No valid active connections found." If I click Edit Connections, it shows Auto eth0 as "Never used". Yet I am using my network connection right now. If I download something, I am getting full performance. I am surfing the net and posting this, now.What has happened to my connection info and how can I fix it?
practically out of the box in U10.10, well modulo a little tweak to force /dev/video0 as the default webcam... (as I have a PCI capture card)...Both upgrade from 10.10 or fresh install of 11.04, in 11.04 sn9c202 fails to work on most webcam apps, apart from xawtv...
I have created a website in php.wamp server is used to run the site.i created the database in phpmyadmin using mysql.These all were done in windowsXP.Now I want to import it into redhat linux system.how can I import database and its tables to rhel4 inorder to working the website properly
I have installed fedora 11 and I have installed on it hosting control paneland for a week the server was working fine for no reasonI have regulated control panel and I have added other functionswhen the hosting control panel was turned off, I have turned off the serverNext day I have turned on a server again and fedora 11 started to go onbut some window where the log in has to be does not appearinstead that window I saw a black screen with the cursorand around the cursor the revolving thingI have tried for several times to load it- it does not workWhat can it be and how can that be fixed
I installed debian etch on my system. Installation done successfully, but when it boots up the X server is not starting and showing error. Note : It is perfectly working with debian lenny. Configuration : Intel DG41RQ ,1GB Ram ,160GB HDD.
I recently moved into a new place and when I hooked up my webserver, I wasn't able to bring up my page, even from localhost. With some digging, it seems that I can't access the database that housed my posts (wordpress installation). I looked for the datadir in MySQL and that directory shows the wordpress directory that should be holding the database and all the files are still there. 1) why the database no longer shows up 2) how to restore the database from the files?
I have a dedicated server running Centos 5.2. I have a Wordpress MU site that's setup over apache 2, mysql 5, php5, and I use phpmyadmin as well. I'm able to read the database as my website appears perfectly fine, however, I can not write to it. What exactly do I need to install on my Centos sever to allow my site to interface with the database? I've used shared servers and VPS's with no problems but this just won't work. The support team seems clueless and I'm ready to ask them to reinstall my entire OS and everything else again.
I'm trying to move a mysql 5.1.50-community InnoDB database from one location to another.When starting the service I get:Starting MySQL.Manager of pid-file quit without updating file [FAILED]I've searched for a way to do this but I can only find people who describe what I've just done.
I'm having trouble with my database server run with PHP & MYSQL; i just installed this system on a SUSE Linux Enterprise Sever; the Server its self is an HP Proliant ML370G with 4GB RAM The system was fine for like 3 weeks until recently when it started slowing down. Apparently, eveything is normal when you are accessing the server, for example when you are browsing on the database web interface; but problem is when you start working in the database, when you try submitting into the database, its really slow on processing, i have to first restart the mysql; Could it be RAM? or the SQL itself?
I'm looking for a way to put a MySQL database in a server's memory. The disks aren't fast enough to keep up with the usage and I don't feel like going for a splitted web&db server yet because of the costs.
Because this involves risks (unless there's a way to read from the memory and write to the memory AND disks?), so I'd prefer that the DB gets copied automatically every hour or so to the local disks.
I've ditched ubuntu for xubuntu 11.04. I love it. The marvellous grid based desktop...the beautiful theme...the ease of customisation...everything. I switched because I didn't like unity.However, I now have a problem. After installing the proprietary ati drivers for my raedon 5xxx card, compz still does not work at all. A lot of other people have been having problems with extreme lag when dragging windows (my unity-likeing school friend included). I don't have this problem because compiz won't work. The weird thing is that in any other 3d tasks the card performs better than on 10.10. For example I can now play oblivion without the characters lacking faces.
I've installed PostgreSQL on Arch Linux & also self generated self signed certificates in /etc/ssl/ directory. My PostgreSQL 'data' directory is /var/lib/postgres/data & I've edited my postgresql.conf file to use SSL however I'm having permission / access problems starting my database using SSL. It can't access the certificates and errors out when I try and start the database engine:
Code: LOG: autovacuum launcher shutting down LOG: shutting down LOG: database system is shut down FATAL: could not load server certificate file "server.crt": No such file or directory code....
I don't know what I need to chown or chmod in order to get PostgreSQL to access my self signed certificates.
I am now able to create the database using PHP and SQL. But it seems I can only do it as MySQL root user.. $dbuser = 'root'; but is there a way to do that as a regular MySQL user?
Can any one tell me how to configure Tomcat ldap URL authentication perfectly? I've tomcat installed with port forwarding to http(80). I could able to confiure apache ldap authentication. For this i modified the file '/etc/apache2/sites-enabled/000-defaults' with the DocumentRoot /var/www.
But for tomcat '/usr/share/tomcat/webapps' I could not able to configure 'server.xml' file perfectly.
I recently installed Ubuntu 10.10 on my Sony Vaio VPCEE2E1E. I've been able to avoid any major problems, however, my onboard sound doesn't work. I've tried plugging speakers into the laptop and this works perfectly. I'm rather confused as to why the onboard sound isn't working though.
Here's the output for lspci on my machine:
Code: **** List of PLAYBACK Hardware Devices **** card 0: SB [HDA ATI SB], device 0: ALC259 Analog [ALC259 Analog] Subdevices: 1/1 Subdevice #0: subdevice #0 card 1: HDMI [HDA ATI HDMI], device 3: ATI HDMI [ATI HDMI]
I tried to install ubuntu 10.04 to a 16 gig thumb drive and the installation went perfectly. However, when I removed the thumb drive and tried to boot the computer back into windows I saw that the installer had installed GRUB on to the hard drive of the computer. Windows runs fine, but it wont start with out the thumb drive that has the ubuntu install on it, this is very bad for me. Is there a way I can remove GRUB with out messing up windows on the computer? i dont have a windows 7 boot disk so this operation would need to be done either in windows (already booted) or ubuntu.
am using zabbix open source solution for systems monitoring. I am facing a problem and discussed it on zabbix forum. my post was as "My zabbix server is behaving abnormally, approximately daily from 9 to 12, the server stop accumulating logs. I observed that the server report is RUNNING but it did not accumulate log values and also the machine have no extra load. Its shown in the graph image attached.t the following reply,"database performance?are you monitoring database IO and available database threads? "So any one have any idea that how can I do this as I am using MySQL as backend database on RHEL 3.
I switched from Windows 7 to Linux and when I'm trying to import my database i get error 1044. It used to work when I was using Windows 7. I was able to export the database from my localhost. However, when I try to import it to the other server I get this:#1044 - Access denied for user ' '@'%' to database'.I have been trying for hours to upload my site from the localhost to another server without any luck..I'm using phpmyadmin to import it.
i installed Fedora 14 on my machine,then i installed postgresql in it i started it and configured it after seeing link [URL] i am able to do su - postgres but when i am trying to create database in it am getting error,It is asking for password then i am giving my root password
createdb company Password: createdb: could not connect to database postgres: FATAL: password authentication failed for user "postgres"
I have suse linux 10.1 that came with whats looks to be a incomplete sql server. If it works I don't know how to use it because w3schools instruction guide does not work with sql. Anyways I was wondering if there's any database software for linux that could be installed in my webpage directory and used by html files. Or if theres any free cgi database software for linux that i could use with html to create database web pages.
I am having a problem restoring a database. Server is Ubuntu 8.04.4 LTS. It appears to wig out at a certain point, when this happens the output on the screen shows;Quote:
Well i have got a problem with connecting to a mysql database using php. I used this package "mysql-noinstall-5.1.44-win32.zip" and extracted it to c:mysql and added c:mysqlin to the PATH variable and used the following command in command prompt to start mysql: c:mysqlinmysqld --standalone
well mysql did start and everything went well accessing mysql in command prompt. Well under the database "mysql" in the table "user" i created a new user "php" with a password="****" and hostname = "localhost" but when i try to access this database with a following php routine:
And when i accesses it with my browser using localtost/test.php, all i get is "localhost" displayed on screen, "Connected to mysql" never gets displayed not i get any error..i am using windows 7(32-bit-ultimate)and mysql 5.1.44.
We have a disaster recovery solution for our database where a dump file is generated daily at 1:00 AM. We have tested importing the file, along with running another sql file that generates the appropriate database user accounts, into a database on a third-party server.
One question that came up was the following: Suppose the database crashes in the middle of the day, prior to that there were transactions that were entered into the database between the time the dump file was generated, and the crash occurred. We can restore the dump file to either the main or backup server. How can the transactions that were made between the time of the dump file and the crash be restored as well?
I am wondering whether it is problematic to let several different programs/php-scripts use the same MySQL-database concurrently, provided that they do not use the same tables?