mysql-admin-updates Mailing List for MySQL-Admin
Brought to you by:
berniwa
You can subscribe to this list here.
2014 |
Jan
(1) |
Feb
|
Mar
|
Apr
|
May
(1) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
---|
From: Érico <eri...@gm...> - 2014-05-30 17:59:42
|
Hello I am studding the mysql-admin tool and just installed it ... when I try to log into my msql server I get the following warnings on localhost/mysql/index.php ... : Warning: mktime(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /users/ericomtx/development/MySQL-Admin/lib/usersystem.lib.php on line 26 Warning: Cannot modify header information - headers already sent by (output started at /users/ericomtx/development/MySQL-Admin/lib/usersystem.lib.php:26) in /users/ericomtx/development/MySQL-Admin/lib/usersystem.lib.php on line 64 Warning: Cannot modify header information - headers already sent by (output started at /users/ericomtx/development/MySQL-Admin/lib/usersystem.lib.php:26) in /Users/ericomtx/development/MySQL-Admin/startpage.php on line 27 Warning: Cannot modify header information - headers already sent by (output started at /users/ericomtx/development/MySQL-Admin/lib/usersystem.lib.php:26) in /Users/ericomtx/development/MySQL-Admin/startpage.php on line 28 Warning: mktime(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /users/ericomtx/development/MySQL-Admin/lib/usersystem.lib.php on line 164 Warning: mktime(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /users/ericomtx/development/MySQL-Admin/lib/usersystem.lib.php on line 231 Warning: mktime(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /users/ericomtx/development/MySQL-Admin/lib/usersystem.lib.php on line 232 Warning: Cannot modify header information - headers already sent by (output started at /users/ericomtx/development/MySQL-Admin/lib/usersystem.lib.php:26) in /users/ericomtx/development/MySQL-Admin/lib/functions.php on line 147 Warning: Cannot modify header information - headers already sent by (output started at /users/ericomtx/development/MySQL-Admin/lib/usersystem.lib.php:26) in /users/ericomtx/development/MySQL-Admin/lib/functions.php on line 148 Warning: Cannot modify header information - headers already sent by (output started at /users/ericomtx/development/MySQL-Admin/lib/usersystem.lib.php:26) in /users/ericomtx/development/MySQL-Admin/templates/normal.inc.php on line 14 *************************************************************************** Warning: mktime(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /users/ericomtx/development/MySQL-Admin/lib/usersystem.lib.php on line 164 Warning: mktime(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /users/ericomtx/development/MySQL-Admin/lib/usersystem.lib.php on line 80 Warning: Cannot modify header information - headers already sent by (output started at /users/ericomtx/development/MySQL-Admin/lib/usersystem.lib.php:164) in /users/ericomtx/development/MySQL-Admin/lib/usersystem.lib.php on line 80 Warning: mktime(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /users/ericomtx/development/MySQL-Admin/lib/usersystem.lib.php on line 80 Warning: Cannot modify header information - headers already sent by (output started at /users/ericomtx/development/MySQL-Admin/lib/usersystem.lib.php:164) in /users/ericomtx/development/MySQL-Admin/lib/usersystem.lib.php on line 80 Warning: Cannot modify header information - headers already sent by (output started at /users/ericomtx/development/MySQL-Admin/lib/usersystem.lib.php:164) in /users/ericomtx/development/MySQL-Admin/lib/functions.php on line 147 Warning: Cannot modify header information - headers already sent by (output started at /users/ericomtx/development/MySQL-Admin/lib/usersystem.lib.php:164) in /users/ericomtx/development/MySQL-Admin/lib/functions.php on line 148 Warning: Cannot modify header information - headers already sent by (output started at /users/ericomtx/development/MySQL-Admin/lib/usersystem.lib.php:164) in /users/ericomtx/development/MySQL-Admin/templates/normal.inc.php on line 14 can you guys help me out to fix these warnings so I can log with out any issues ? Thks !! |
From: Érico <eri...@gm...> - 2014-01-16 18:24:25
|
Hi I have installed mysql admin on my macbook pro ( 10.6.8 ) local environment I am able to connect to mysql through command line : ericomtxmacbookpro:bin ericomtx$ ./mysql -u root -p mysql-admin Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 31 Server version: 5.6.15 MySQL Community Server (GPL) Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> ... I am also albe to access the db through eclipse using jconnector ... but I can't access the aplication through the web ( apache 2.2.26 ) I get the error : Access denied for user 'root'@'localhost' (using password: YES) or Access denied for user 'root'@'localhost' (using password: NO) ... this also works ... my environment : ifconfig -a lo0: flags=8049<UP,LOOPBACK,RUNNING,MULTICAST> mtu 16384 inet6 ::1 prefixlen 128 inet6 fe80::1%lo0 prefixlen 64 scopeid 0x1 inet 127.0.0.1 netmask 0xff000000 gif0: flags=8010<POINTOPOINT,MULTICAST> mtu 1280 stf0: flags=0<> mtu 1280 fw0: flags=8863<UP,BROADCAST,SMART,RUNNING,SIMPLEX,MULTICAST> mtu 4078 lladdr 70:cd:60:ff:fe:eb:72:ea media: autoselect <full-duplex> status: inactive en1: flags=8863<UP,BROADCAST,SMART,RUNNING,SIMPLEX,MULTICAST> mtu 1500 ether e4:ce:8f:04:7c:f8 inet6 fe80::e6ce:8fff:fe04:7cf8%en1 prefixlen 64 scopeid 0x5 inet 169.254.99.150 netmask 0xffff0000 broadcast 169.254.255.255 media: autoselect status: active en0: flags=8863<UP,BROADCAST,SMART,RUNNING,SIMPLEX,MULTICAST> mtu 1500 ether c8:2a:14:1a:47:ea media: autoselect (none) status: inactive wc2: flags=822<BROADCAST,SMART,SIMPLEX> mtu 1500 ether 00:02:55:11:19:76 media: 1000baseT (<unknown type>) ========================================================================= mac:bin ericomtx$ nslookup localhost ;; connection timed out; no servers could be reached ========================================================================= mac:bin ericomtx$ netstat -an | grep 3306 tcp46 0 0 *.3306 *.* LISTEN tcp4 0 0 *.3306 *.* LISTEN ========================================================================= mac:bin ericomtx$ netstat -ln | grep mysql ffffff801403c280 stream 0 0 0 ffffff801403b200 0 0 /tmp/mysql.sock ffffff801403a9c0 stream 0 0 ffffff801bbb78b8 0 0 0 /tmp/mysql.sock ========================================================================= mac:lib ericomtx$ ps xa | grep mysqld 2175 s000 S 0:00.02 /bin/sh /Users/ericomtx/development/mysql/mysql-5.6.15-osx10.6-x86/bin/mysqld_safe --datadir=/Users/ericomtx/development/mysql/mysql-5.6.15-osx10.6-x86/data --pid-file=/Users/ericomtx/development/mysql/mysql-5.6.15-osx10.6-x86/data/mac.local.pid 2273 s000 S 0:00.35 /Users/ericomtx/development/mysql/mysql-5.6.15-osx10.6-x86/bin/mysqld --basedir=/Users/ericomtx/development/mysql/mysql-5.6.15-osx10.6-x86 --datadir=/Users/ericomtx/development/mysql/mysql-5.6.15-osx10.6-x86/data --plugin-dir=/Users/ericomtx/development/mysql/mysql-5.6.15-osx10.6-x86/lib/plugin --user=mysql --log-error=/Users/ericomtx/development/mysql/mysql-5.6.15-osx10.6-x86/data/mac.local.err --pid-file=/Users/ericomtx/development/mysql/mysql-5.6.15-osx10.6-x86/data/mac.local.pid my /etc/hosts : 127.0.0.1 localhost.local localhost ::1 localhost6.local6 localhost6 127.0.0.1 mac mac mac: ericomtx ========================================================================= and ... my PASS.php : <?php // Connection settings $RMUSER = "root"; //username for mysql server $RMPASS = "my_correct_pwd"; //password for mysql server $RMSERVER = "localhost"; //server address $RMDATABASE = "mysql-admin"; //database name ?> please any idea on what this be ? |