mysql-admin-updates Mailing List for MySQL-Admin
Brought to you by:
berniwa
Menu
▾
▴
mysql-admin-updates — Information about new updates, bugfixes, releases
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 ?
|
