PHP Warning: mysqli_connect(): (28000/1045): Access denied for user 'root'@'localhost' (using password: YES) in /var/www/..../libraries/database/mysqli_connection.php on line 23
Can't connect to MySQL database (root@mysql).
I have been following this guide to install Apache, PHP & mysql - [URL]. When I get up to the step 'mysql -u root' I get given this error:
Code:
tom@tom-laptop:~$ mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
How do I overcome this?
i have tried to follow some the tutorials on google to setup mysql for remote access however, cannot seem to do it. am i missing something.
i have edited /etc/mysql/my.cnf bind-address directive to a static ip address. then, i grant user@'%' access to database and restart mysql
after doing all that, when i try to remote access mysql i get "Access denied for user"
for some reason root lost grant privileges and I can't get it back. The user got grant_priv = 'Y' in the usertable. I've tried to reset all the priviliges to the user by killing MySQL process and started up again without grant options with no luck. I've also tried lots of other things but can't seem to get it work. Here is what I get: Quote:
[root@xxxxxxxxx mysqldba]# mysql -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 2
Server version: 5.0.77 Source distribution
[Code]...
This is my first post, I hope I'm the the right place. I installed mysql mysql-server php-mysql perl-DBD-mysql libdbi-dbd-mysql via "yum install -y" on a server running CentOS 5.3 X86_64 The install completes successful with no errors, but once I start mysqld via "chkconfig --level 35 mysqld on" ; "service mysqld start" There are no errors in /var/log/mysqld.log netstat shows mysqld listening on 3306 and localhost is in /etc/hosts
[Code]...
Just upgraded (libudev0 and related) and system fails to mount other partitions, gives a lot of errors and drops to single mode.
View 14 Replies View RelatedI am an old Debian user, ho just reinstalled it again to see how it evolved since my las version (3.2). I am sharing it with Arch Linux, And decided to let bot of them. I am using GDM compiled and configured in Arch, and removed GDM2 from Debian (i just like the easy menu.list from the old GDM). The problem is that when i update the kernel, it didn't fing GDM and drops an error message. I tried removing the distro-preconfigured Kernels, as i compiled my own 3.0.0-rc2 Kerenel, but i cant delete the previous ones. Now everytime i do an install or uptgrade, apt-get drops wastes some time, and drops an error message:
[code]...
What can i do? i googled some similar errors, but where just messed up mirror.lists, or similar, i know it isnt the cause of fail.
i have the basic knowledge of networking. a week ago i installed debian Lenny version on an old pentium 3. in addition i installed a ddclient configured it according to many tutorials.i searched google a few days but didnt find my case. i ran the folowing command :
ddclient -daemon=0 -debug -verbose -noquiet
output:
debian:~# ddclient -daemon=0 -debug -verbose -noquiet
=== opt ====
opt{cache} : <undefined>
[Code]...
i installed ddclient before installing apache. the 10.0.0.10 address is the server address in my d link router behind NAT.
I've done an upgrade from lenny to squeeze.Now, I'm getting a lot of udev warning messages at the boot time.Knows someone howto remove them?
View 6 Replies View RelatedI am using Debian testing i386. Just upgraded to 2.6.39-2-686-pae. After reboot, and ever since, I am getting warning: WARNING: Could not find hdaps input device (No such file or directory). You may be using an incompatible version of the hdaps module. Falling back to reading the position from sysfs (uses more power). Use '-y' to silence this warning.
View 1 Replies View RelatedI have a issue with my host file
127.0.0.1 debianserver
ping debianserver
ping: unknown host debianserver
# hostname
debianserver
[Code]....
I running xfce4.8 and when I start my session I get a warning: xfce wiil not run properly add Debianser to the host...
I do not know if this is really something I should worry about. I am running Debian testing on my laptop (HP Pavillon dv6). Today, the aptitude update---aptitude upgrade gave me a new kernel (2.6.39). However, if I boot with that kernel, I get a warning (do not know if that is the way I should call this) telling me that the machine failed to get the i915 symbols so turbo graphics will be disabled.I have not done any serious test, but at first sight I do not notice any difference performance-wise with respect to the previous kernel. what am I supposed to do to fix this?
View 8 Replies View RelatedI am not sure if this is the correct forum to post this as I have usually been able to find the answers from other peoples threads.The error I receive is below.(changed "at" as can't post links)"#1045 - Access denied for user 'root' at 'localhost' (using password: NO)" Not entirely sure what has happened here. I have had this server running for a long time and today it seems to have spat it's dummy out!I have checked the config.inc.php and the controluser and controlpass are entered correctly so the error saying a password is not being usPHP Code:Thisis needed for cookie based authentication to encrypt password incookie
View 2 Replies View Related/dev/sda 74.53gb. Here are two partitions sda1 243.13mib (33.92 used), flags 'boot', and sda2 74.29gb flags 'lvm'. Filesystem for sda1 is ext2, for sda2 'unknown' and it gives a warning "Unable to detect filesystem". At last shut down I also notices red text that said something about logical volumes and lvm.
[Code]...
I recently installed Debian Squeeze on my desktop, replacing an Ubuntu 9.04 variant (CrunchBang). Since then, I've been unable to use gnomad2 to scan my 30GB Creative Zen Touch. Here is the relevant portion of /var/log/messages:
Code:
Mar 28 17:31:38 squeezebang kernel: [170473.176033] usb 2-4: new high speed USB device using ehci_hcd and address 10
Mar 28 17:31:39 squeezebang kernel: [170473.309328] usb 2-4: New USB device found, idVendor=041e, idProduct=413e
Mar 28 17:31:39 squeezebang kernel: [170473.309334] usb 2-4: New USB device strings: Mfr=1, Product=2, SerialNumber=3
Mar 28 17:31:39 squeezebang kernel: [170473.309339] usb 2-4: Product: Creative Zen Vision:M
error 4 in gnomad2[8048000+28000]
I haven't tried installing an older version under Squeeze, but that might be my next step.
I recently did a fresh install of current and once I had it up and running I compiled a fresh 2.6.33 kernel using my old config file, but now I get this warning durning boot, specifically during module loading WARNING: All config files need .conf: /etc/modprobe.d/sound, it will be ignored in a future release. This doesn't seem to be causing any problems but I am curious to know what the message meams? I checked /etc/modprobe but everything looks normal.
View 1 Replies View RelatedI installed TeXlive 2010 and when i compile this command pdflatex it shows the following error:
warning: kpathsea: configuration file texmf.cnf not found in these directories: /usr/bin:/usr:/usr/share/texlive:/usr/bin/share/texmf-local/web2c:/usr/share/texmf-local/web2c:/usr/share/texlive/share/texmf-local/web2c:/usr/bin/texmf-local/web2c:/usr/texmf-local/web2c:/usr/share/texlive/texmf-local/web2c:/usr/bin/share/texmf/web2c:/usr/share/texmf/web2c:/usr/share/texlive/share/texmf/web2c:/usr/bin/texmf/web2c:/usr/texmf/web2c:/usr/share/texlive/texmf/web2c.
I had (and still do) a working dual-boot XP/Karmic (GRUB version 1.97 beta4). I shrank the Ubuntu partition and set up partitions and installed Debian 5.04. When I got to the point of installing GRUB, I told Debian to install grub to MBR. On rebooting, Ubuntu was not an option on the NEW (looked different) grub menu.Maybe it was GRUB2? Could boot to either XP or Debian though.
Thought easiest thing was to reinstall Ubuntu since it seems to "see" other OS's more reliably. So I did, and installed GRUB again during its install to MBR. Then, all three were in the GRUB menu (version 1.97 beta4 again), but when tried booting to Debian, got an error (forget the wording), but think it was because the partitions got renumbered when installing Ubuntu.
SO, reinstalled Debian, reformatting the partitions but not deleting them first so the numbering stayed the same. When got to the part for installing GRUB, I told it to skip (I got some kind of error that said "Install failed. This is a fatal error. You will have to boot with an external device..."), hoping now the current GRUB would work.
Now, all three were on the GRUB menu, but when I tried to boot Debian, I got "no such device" and a list of numbers/letters after it. And "press any key to continue", which takes you back to the GRUB menu (version 1.97 beta4, by the way).
O.K., did sudo update-grub in ubuntu and rebooted. Now, Debian 5.04 shows as last entry in GRUB, and choosing it starts a boot, which hangs at "Begin: Waiting for root file system....".
Waiting long enough at the "Waiting for root file system..." hang results in a series of notifications:
WARNING bootdevice may be renamed. Try root=dev/hda3
Gave up waiting for root device. Common problems:
-Boot args (cat /proc/cmdline)
-Check rootdelay= (did the system wait long enough?)
-Check root= (did the sytem wait for the right device?)
-Missing modules (cat /proc/modules; ls /dev)
ALERT! /dev/sda3 does not exist. Dropping to a shell!
In Gparted, the partition with Debian root is hdc3, although on the GRUB menu it's listed as /dev/sda3. However, in Gparted the Windows partition is hdc1 and on GRUB it's /dev/sda1, and it boots fine.....
Is my Debian install just borked? Did telling it to skip installing a bootloader (I got some kind of error that said "Install failed. This is a fatal error. You will have to boot with an external device..." ruin it?
If skipping the bootloader install did ruin it, how do you install Debian without borking your current GRUB? That's what happened the first time.
I need to get an old MySQL Client(4.1)to connect to an even older MySQL Server (3.23).The goal is to do a Java/JDBC connect to the old Linux/MySQL 3.23 database, in order to update text information for a Lucene search (which will also run on linuxdev2). The problem is that I can't connect to the Linux/MySQL 3.23 server from a remote Linux/MySql 4.1 client. I can't connect from JDBC; I can't connect from "mysql":
Code:
LOCAL (intranet):
mysql -uSOMEUSER -pSOMEPASSWORD mysql => OK
REMOTE (from linuxdev2):
mysql -uSOMEUSER -pSOMEPASSWORD -hintranet mysql => FAILS:
ERROR 1045 (00000): Access denied for user: 'SOMEUSER@linuxdev2' (Using password: YES)
[code]....
I'm running Debian Testing and since some time ago I'm getting the following messages:Any ideas how to solve this warnings?
(gtk-update-icon-cache:9204): GdkPixbuf-WARNING **: Cannot open pixbuf loader module file '/usr/lib/x86_64-linux-gnu/gdk-pixbuf-2.0/2.10.0/loaders.cache': No such file or directory
Processing triggers for gconf2 ...
[code]....
i just tried to install Ubuntu Netbook 10.04 on my old Amilo Lifebook P Series. But after the boot screen and the choice to install Ubuntu i get stuck at the Ubuntu screen with the little dots on the bottom If I hit esc i can see the warning (process 257): GLib-WARNING **: getpwuid_(r) failed due to unknown user id (0)
View 2 Replies View RelatedWhen installing updates, I am getting a warning that some updates are unauthenticated and may be malicious. These are all "lib" files. I am not willing to corrupt this laptop. That's why I moved to Linux in the first place..
View 12 Replies View RelatedJust finnished a fresh install of Squeeze. In a console, as root, when i type gedit i get: # gedit No protocol specified
(gedit:24284): Gtk-WARNING **: cannot open display: :0.0
I'd like to clean packages on my Lenny with Gnome using apt-get autoremove and I get this output:
Code:
# apt-get autoremove
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following packages were automatically installed and are no longer required:
bluez-gnome libsdl1.2debian libsdl1.2debian-alsa libepc-ui-1.0-1 python-gst0.10 libmtp7 gcalctool libpth20 gnome-nettool libepc-1.0-1 libgtk-vnc-1.0-0 libgksu1.2-0
python-notify aspell pkg-config libgda3-common python-gnome2-extras gucharmap libgksuui1.0-1 libosp5 evolution-exchange libspectre1 gnome-network-admin libsvga1
gnome-power-manager unzip gnome-cards-data totem-plugins gnome-screensaver rhythmbox w3c-dtd-xhtml python-gdata gedit liblircclient0 python-gtksourceview2 gtk2-engines-pixbuf
system-config-printer libpt-1.10.10-plugins-alsa gnome-themes seahorse libggzmod4 mysql-common totem-common vinagre swfdec-gnome libpt-1.10.10 libgpod3 libgadu3 libgalago3
guile-1.8-libs libmysqlclient15off python-gtkmozembed python-gtkhtml2 p7zip gedit-common gnome-themes-extras libhesiod0 finger libmusicbrainz4c2a fast-user-switch-applet arj
gnome-volume-manager gtk2-engines libgtksourceview2.0-common libkpathsea4 eog libgtksourceview2.0-0 libavahi-gobject0 gnome-backgrounds python-eggtrayicon python-sexy
python-xdg gnome-spell libggz2 vino evince gnome-app-install libopal-2.2 totem-gstreamer libgnomevfs2-bin zip python-gdbm gnome-core dmz-cursor-theme python-4suite-xml
liblua5.1-0 libmeanwhile1 libgda3-3 svgalibg1 libpt-1.10.10-plugins-v4l libgpgme11 libggzcore9 libgmyth0 gconf-editor libzephyr3 gnome-system-tools gnuchess
gstreamer0.10-gnomevfs libavahi-ui0 gstreamer0.10-tools totem-mozilla libgdl-1-0 file-roller libopenobex1 libspeexdsp1 libgdl-1-common gnome-vfs-obexftp
The following packages will be REMOVED:
arj aspell bluez-gnome dmz-cursor-theme eog evince evolution-exchange fast-user-switch-applet file-roller finger gcalctool gconf-editor gedit gedit-common gnome-app-install
gnome-backgrounds gnome-cards-data gnome-core gnome-nettool gnome-network-admin gnome-power-manager gnome-screensaver gnome-spell gnome-system-tools gnome-themes
gnome-themes-extras gnome-vfs-obexftp gnome-volume-manager gnuchess gstreamer0.10-gnomevfs gstreamer0.10-tools gtk2-engines gtk2-engines-pixbuf gucharmap guile-1.8-libs
libavahi-gobject0 libavahi-ui0 libepc-1.0-1 libepc-ui-1.0-1 libgadu3 libgalago3 libgda3-3 libgda3-common libgdl-1-0 libgdl-1-common libggz2 libggzcore9 libggzmod4 libgksu1.2-0
libgksuui1.0-1 libgmyth0 libgnomevfs2-bin libgpgme11 libgpod3 libgtk-vnc-1.0-0 libgtksourceview2.0-0 libgtksourceview2.0-common libhesiod0 libkpathsea4 liblircclient0
liblua5.1-0 libmeanwhile1 libmtp7 libmusicbrainz4c2a libmysqlclient15off libopal-2.2 libopenobex1 libosp5 libpt-1.10.10 libpt-1.10.10-plugins-alsa libpt-1.10.10-plugins-v4l
libpth20 libsdl1.2debian libsdl1.2debian-alsa libspectre1 libspeexdsp1 libsvga1 libzephyr3 mysql-common p7zip pkg-config python-4suite-xml python-eggtrayicon python-gdata
python-gdbm python-gnome2-extras python-gst0.10 python-gtkhtml2 python-gtkmozembed python-gtksourceview2 python-notify python-sexy python-xdg rhythmbox seahorse svgalibg1
swfdec-gnome system-config-printer totem-common totem-gstreamer totem-mozilla totem-plugins unzip vinagre vino w3c-dtd-xhtml zip
0 upgraded, 0 newly installed, 107 to remove and 0 not upgraded.
After this operation, 216MB disk space will be freed.
Do you want to continue [Y/n]?
Have you never get problems after apt-get autoremove?
Im trying to access gparted, i get an error
Quote:
(gpartedbin:4918): Gtk-WARNING **: cannot open display:
I am connect via vnc if this helps.
Ubuntu has been very good for us, fast, small foot print, But just yesterday it decided not to boot up. It gets to the login screen, and shows a warning... "Install problem, the Gnome power management configuration installed incorrectly, contact your administrator" What can I do to free this up?
View 1 Replies View Relatedi was trying to allow remote access to mysql by following mysql was running perfectly until i got here :
Code:
/sbin/iptables -A INPUT -i eth0 -s 192.168.1.0/24 -p tcp --destination-port 3306 -j ACCEPT
i changed my.cnf bind-address line to : "bind-address = 127.0.0.1" and nothing
[code]....
On running aptitude update and then aptitude upgrade following warning notedfollowing packages have been kept back:
[code]...
I installed Sun Java yesterday and got a NOT AUTHENTICATED warning for the sun-java6-plugin. It seems to be in the non-free repository:
[URL]
Is there a key I have neglected to download, or is the package unsigned for some reason?
I have made two partitions / and /home . / is where all the packages and other stuff lives and /home is where user i.e. my data lives. I am sure everybody knows the 'disk space is less' warning dialog box when either we install too many packages or when we download many things. Now the last time it happened by mistake I clicked on do not show more warnings. Now I want to have that warning dialog box back. looked at System > Preferences submenu as well as System > Administration but have not been able to find any info. on the same.
View 5 Replies View Related