Hi,
i have read to connect to the mysql data base i have to write something like this:
shell> mysql -h ServerName -u UserName -p
But what is the exactly command in XAMPP?
Bye
shell> mysql -h ServerName -u UserName -p
Wiedmann wrote:shell> mysql -h ServerName -u UserName -p
With this command you are using the mysql binary from your system, and not that one from XAMPP which is in "/opt/lampp/bin".
/opt/lampp/bin/mysql -u tirengarfio -p (being "tirengarfio" the login to access my session in Ubuntu.)
Wiedmann wrote:MySQL is not using your system users. In a fresh XAMPP installation, you have e.g. a MySQL user "root".
but are you speaking about the root user of my system
Wiedmann wrote:MySQL is not using your system users
or is another root user (maybe the root user of MySQL o XAMPP)?
Wiedmann wrote:In a fresh XAMPP installation, you have e.g. a MySQL user "root".
but i password is requested, what is that password?but i password is requested, what is that password?
Wiedmann wrote:but i password is requested, what is that password?but i password is requested, what is that password?
Ever read some docu?
--> http://www.apachefriends.org/en/xampp-linux.html#381
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/lampp/var/mysql/mysql.sock' (2)
Wiedmann wrote:ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/lampp/var/mysql/mysql.sock' (2)
Sure MySQL is running?
Wiedmann wrote:If you want know if MySQL is running, you must use e.g. "ps" or look into the "*.err" file from MySQL.
tirengarfio@tirengarfio-laptop:/opt/lampp$ ps -A
PID TTY TIME CMD
1 ? 00:00:01 init
2 ? 00:00:00 kthreadd
3 ? 00:00:00 migration/0
4 ? 00:00:00 ksoftirqd/0
5 ? 00:00:00 watchdog/0
6 ? 00:00:00 events/0
7 ? 00:00:00 khelper
41 ? 00:00:00 kblockd/0
44 ? 00:00:00 kacpid
45 ? 00:00:00 kacpi_notify
87 ? 00:00:00 kseriod
120 ? 00:00:00 pdflush
121 ? 00:00:00 pdflush
122 ? 00:00:00 kswapd0
163 ? 00:00:00 aio/0
1366 ? 00:00:02 ata/0
1370 ? 00:00:00 ata_aux
1383 ? 00:00:00 scsi_eh_0
1385 ? 00:00:00 scsi_eh_1
2327 ? 00:00:00 kjournald
2532 ? 00:00:00 udevd
2741 ? 00:00:00 kpsmoused
3966 tty4 00:00:00 getty
3967 tty5 00:00:00 getty
3972 tty2 00:00:00 getty
3974 tty3 00:00:00 getty
3977 tty6 00:00:00 getty
4020 ? 00:00:00 vboxadd-timesyn
4188 ? 00:00:00 acpid
4230 ? 00:00:00 kondemand/0
4295 ? 00:00:00 syslogd
4344 ? 00:00:00 dd
4346 ? 00:00:00 klogd
4368 ? 00:00:00 dbus-daemon
4384 ? 00:00:00 NetworkManager
4398 ? 00:00:00 NetworkManagerD
4411 ? 00:00:00 system-tools-ba
4431 ? 00:00:00 avahi-daemon
4432 ? 00:00:00 avahi-daemon
4461 ? 00:00:00 cupsd
4557 ? 00:00:00 dhcdbd
4576 ? 00:00:00 hald
4579 ? 00:00:00 console-kit-dae
4641 ? 00:00:00 hald-runner
4653 ? 00:00:00 hald-addon-inpu
4662 ? 00:00:00 hald-addon-acpi
4663 ? 00:00:00 hald-addon-stor
4670 ? 00:00:02 hald-addon-stor
4710 ? 00:00:00 hcid
4719 ? 00:00:00 btaddconn
4720 ? 00:00:00 btdelconn
4731 ? 00:00:00 bluetoothd-serv
4732 ? 00:00:00 bluetoothd-serv
4737 ? 00:00:00 krfcommd
4778 ? 00:00:00 dhclient
4787 ? 00:00:00 gdm
4788 ? 00:00:00 gdm
4794 tty7 00:02:49 Xorg
4844 ? 00:00:00 atd
4858 ? 00:00:00 cron
4945 tty1 00:00:00 getty
5028 ? 00:00:02 gconfd-2
5030 ? 00:00:00 gnome-keyring-d
5031 ? 00:00:00 x-session-manag
5086 ? 00:00:00 seahorse-agent
5094 ? 00:00:00 dbus-daemon
5095 ? 00:00:03 gnome-settings-
5099 ? 00:00:01 pulseaudio
5100 ? 00:00:00 gconf-helper
5114 ? 00:00:12 gnome-screensav
5115 ? 00:00:08 metacity
5117 ? 00:00:08 gnome-panel
5118 ? 00:00:03 nautilus
5127 ? 00:00:00 bonobo-activati
5146 ? 00:00:00 gvfsd
5150 ? 00:00:00 bluetooth-apple
5152 ? 00:00:00 update-notifier
5156 ? 00:00:00 evolution-alarm
5157 ? 00:00:00 tracker-applet
5163 ? 00:00:04 trackerd
5167 ? 00:00:00 python
5168 ? 00:00:03 nm-applet
5170 ? 00:00:00 gnome-power-man
5171 ? 00:00:00 gnome-volume-ma
5177 ? 00:00:10 VBoxClient
5249 ? 00:00:00 evolution-data-
5254 ? 00:00:00 evolution-excha
5256 ? 00:00:00 gvfsd-burn
5259 ? 00:00:00 trashapplet
5266 ? 00:00:00 gvfsd-trash
5313 ? 00:00:01 deskbar-applet
5316 ? 00:00:00 fast-user-switc
5320 ? 00:00:00 mixer_applet2
5331 ? 00:00:00 gnome-vfs-daemo
5347 ? 00:03:21 firefox
5389 ? 00:00:01 notification-da
5406 ? 00:00:00 gtk-gnash <defunct>
5418 ? 00:00:06 gnome-terminal
5420 ? 00:00:00 gnome-pty-helpe
5421 pts/0 00:00:00 bash
5474 ? 00:00:00 httpd
5534 ? 00:00:00 proftpd
5565 ? 00:00:00 httpd
5597 ? 00:00:00 httpd
5601 ? 00:00:00 httpd
5603 ? 00:00:00 httpd
5605 ? 00:00:00 httpd
5608 ? 00:00:00 httpd
6001 ? 00:00:00 gvfsd-computer
6008 ? 00:00:07 file-roller
6318 pts/0 00:00:00 ps
i think mysql is not in the list,
Wiedmann wrote:Look into the MySQL "*.err" file what's the problem.
090305 11:40:43 mysqld_safe Starting mysqld daemon with databases from /opt/lampp/var/mysql
/opt/lampp/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
090305 11:40:44 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
090305 11:40:45 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name /opt/lampp/var/mysql/ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
090305 11:40:45 mysqld_safe mysqld from pid file /opt/lampp/var/mysql/tirengarfio-laptop.pid ended
090306 12:34:02 mysqld_safe Starting mysqld daemon with databases from /opt/lampp/var/mysql
/opt/lampp/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
090306 12:34:03 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
090306 12:34:04 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name /opt/lampp/var/mysql/ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
090306 12:34:04 mysqld_safe mysqld from pid file /opt/lampp/var/mysql/tirengarfio-laptop.pid ended
090307 22:33:50 mysqld_safe Starting mysqld daemon with databases from /opt/lampp/var/mysql
/opt/lampp/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
090307 22:33:51 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
090307 22:33:51 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name /opt/lampp/var/mysql/ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
090307 22:33:51 mysqld_safe mysqld from pid file /opt/lampp/var/mysql/tirengarfio-laptop.pid ended
090308 20:08:11 mysqld_safe Starting mysqld daemon with databases from /opt/lampp/var/mysql
/opt/lampp/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
090308 20:08:11 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
090308 20:08:11 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name /opt/lampp/var/mysql/ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
090308 20:08:11 mysqld_safe mysqld from pid file /opt/lampp/var/mysql/tirengarfio-laptop.pid ended
090314 20:35:10 mysqld_safe Starting mysqld daemon with databases from /opt/lampp/var/mysql
/opt/lampp/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
090314 20:35:11 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
090314 20:35:11 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name /opt/lampp/var/mysql/ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
090314 20:35:11 mysqld_safe mysqld from pid file /opt/lampp/var/mysql/tirengarfio-laptop.pid ended
090314 20:36:30 mysqld_safe Starting mysqld daemon with databases from /opt/lampp/var/mysql
/opt/lampp/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
090314 20:36:30 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
090314 20:36:31 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name /opt/lampp/var/mysql/ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
090314 20:36:31 mysqld_safe mysqld from pid file /opt/lampp/var/mysql/tirengarfio-laptop.pid ended
090314 20:42:44 mysqld_safe Starting mysqld daemon with databases from /opt/lampp/var/mysql
/opt/lampp/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
090314 20:42:44 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
090314 20:42:44 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name /opt/lampp/var/mysql/ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
090314 20:42:44 mysqld_safe mysqld from pid file /opt/lampp/var/mysql/tirengarfio-laptop.pid ended
tirengarfio@tirengarfio-laptop:/opt$ /opt/lampp/bin/mysql_upgrade
Warning: World-writable config file '/opt/lampp/etc/my.cnf' is ignored
Looking for 'mysql' as: /opt/lampp/bin/mysql
Looking for 'mysqlcheck' as: /opt/lampp/bin/mysqlcheck
Running 'mysqlcheck'...
/opt/lampp/bin/mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/opt/lampp/var/mysql/mysql.sock' (2) when trying to connect
FATAL ERROR: Upgrade failed
Users browsing this forum: No registered users and 37 guests