Ask Question Forum:
Model Library:2025-02-08 Updated:A.I. model is online for auto reply question page
C
O
M
P
U
T
E
R
2
8
Show
#
ASK
RECENT
←
- Underline
- Bold
- Italic
- Indent
- Step
- Bullet
- Quote
- Cut
- Copy
- Paste
- Table
- Spelling
- Find & Replace
- Undo
- Redo
- Link
- Attach
- Clear
- Code
Below area will not be traslated by Google,you can input code or other languages
Hint:If find spelling error, You need to correct it,1 by 1 or ignore it (code area won't be checked).
X-position of the mouse cursor
Y-position of the mouse cursor
Y-position of the mouse cursor
Testcursor
caretPos
Attachment:===
Asked by duncanb7
at 2024-08-03 05:09:23
ModifyPoint:500 Replies:11 POST_ID:828682USER_ID:11059
Topic:
PHP Scripting Language;MySQL Server;Linux
Dear Mysql and Experts,
I 've not used mysql for a long long time. And my Cpanel was expired from last two months, in other words, I can not use my CPanel to do any mysql work or admin.
And when I try to access mysql on my chrome browser at http://mysite.com:3306 that I can
not access the mysql admin page, just have this error
pcd273039.netvigator.com is probably my ISP IP to my window desktop
mysite.com is Linux CentOS apache server that is VPS server
Now I go to root shell to check /etc/my.cnf, there is nothing there
that included into the following code area with netstat -tapn output for your review
And it shows port 3306 is listening ..
So I try googl it, http://www.howtogeek.com/howto/ubuntu/access-your-mysql-server-remotely-over-ssh/
for using SSH tunneling to access, but also fail
Please advise, how to access back mysql at my linux server without CPanel on my chrome browser at my window 7 desktop
Please advise
Duncan
I 've not used mysql for a long long time. And my Cpanel was expired from last two months, in other words, I can not use my CPanel to do any mysql work or admin.
And when I try to access mysql on my chrome browser at http://mysite.com:3306 that I can
not access the mysql admin page, just have this error
'Q ¿jHost 'pcd273039.netvigator.com' is not allowed to connect to this MySQL server"
pcd273039.netvigator.com is probably my ISP IP to my window desktop
mysite.com is Linux CentOS apache server that is VPS server
Now I go to root shell to check /etc/my.cnf, there is nothing there
that included into the following code area with netstat -tapn output for your review
And it shows port 3306 is listening ..
So I try googl it, http://www.howtogeek.com/howto/ubuntu/access-your-mysql-server-remotely-over-ssh/
for using SSH tunneling to access, but also fail
Please advise, how to access back mysql at my linux server without CPanel on my chrome browser at my window 7 desktop
Please advise
Duncan
my.cnf file=========[mysqld]innodb-file_per_table=1================netstat -tapn command===================Active Internet connections (servers and established)Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program nametcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN 561/sshdtcp 0 0 0.0.0.0:25 0.0.0.0:* LISTEN 671/eximtcp 0 0 127.0.0.1:953 0.0.0.0:* LISTEN 536/namedtcp 0 0 0.0.0.0:443 0.0.0.0:* LISTEN 863/httpdtcp 0 0 0.0.0.0:2077 0.0.0.0:* LISTEN 966/cpdavd - accepttcp 0 0 0.0.0.0:2078 0.0.0.0:* LISTEN 966/cpdavd - accepttcp 0 0 0.0.0.0:993 0.0.0.0:* LISTEN 841/dovecottcp 0 0 0.0.0.0:2082 0.0.0.0:* LISTEN 962/cpsrvd (SSL) -tcp 0 0 0.0.0.0:2083 0.0.0.0:* LISTEN 962/cpsrvd (SSL) -tcp 0 0 0.0.0.0:995 0.0.0.0:* LISTEN 841/dovecottcp 0 0 0.0.0.0:2086 0.0.0.0:* LISTEN 962/cpsrvd (SSL) -tcp 0 0 0.0.0.0:2087 0.0.0.0:* LISTEN 962/cpsrvd (SSL) -tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 669/mysqldtcp 0 0 0.0.0.0:587 0.0.0.0:* LISTEN 671/eximtcp 0 0 0.0.0.0:110 0.0.0.0:* LISTEN 841/dovecottcp 0 0 0.0.0.0:2095 0.0.0.0:* LISTEN 962/cpsrvd (SSL) -tcp 0 0 0.0.0.0:143 0.0.0.0:* LISTEN 841/dovecottcp 0 0 127.0.0.1:783 0.0.0.0:* LISTEN 831/spamd.pid --maxtcp 0 0 0.0.0.0:2096 0.0.0.0:* LISTEN 962/cpsrvd (SSL) -tcp 0 0 0.0.0.0:80 0.0.0.0:* LISTEN 863/httpdtcp 0 0 0.0.0.0:465 0.0.0.0:* LISTEN 671/eximtcp 0 0 0.0.0.0:21 0.0.0.0:* LISTEN 870/pure-ftpd (SERVtcp 0 0 212.1.209.242:53 0.0.0.0:* LISTEN 536/namedtcp 0 0 212.1.213.78:53 0.0.0.0:* LISTEN 536/namedtcp 0 0 127.0.0.1:53 0.0.0.0:* LISTEN 536/namedtcp 0 104 212.1.213.78:22 203.218.63.39:58484 ESTABLISHED 1160/sshdtcp 0 0 212.1.213.78:40658 113.28.163.230:80 TIME_WAIT -tcp 0 0 127.0.0.1:49975 127.0.0.1:80 TIME_WAIT -tcp 0 0 :::22 :::* LISTEN 561/sshdtcp 0 0 :::25 :::* LISTEN 671/eximtcp 0 0 :::587 :::* LISTEN 671/eximtcp 0 0 :::465 :::* LISTEN 671/eximtcp 0 0 :::21 :::* LISTEN 870/pure-ftpd (SERV 1:2:3:4:5:6:7:8:9:10:11:12:13:14:15:16:17:18:19:20:21:22:23:24:25:26:27:28:29:30:31:32:33:34:35:36:37:38:39:40:41:42:43:
Author: duncanb7 replied at 2024-08-04 01:08:29
Monitor key word for solving this thread
For my memo (reminder)
=================================
access mysql montor program SQLyog need to use SSH tunneling
with SSH login and password, otherwise
will get Error 1130 host is not connected to mysql server
For my memo (reminder)
=================================
access mysql montor program SQLyog need to use SSH tunneling
with SSH login and password, otherwise
will get Error 1130 host is not connected to mysql server
Expert: Dave Baldwin replied at 2024-08-04 01:05:12
'my.cnf' is not required to run MySQL.
The MySQL server does not provide a web page for any purpose. On web servers that support PHP, phpMyAdmin is often used.
The MySQL server does not provide a web page for any purpose. On web servers that support PHP, phpMyAdmin is often used.
Author: duncanb7 replied at 2024-08-04 01:03:10
Yes, you are right, I may like this mysql monitor tool , https://www.webyog.com/
for 30-day free trial only
for 30-day free trial only
Author: duncanb7 replied at 2024-08-04 00:17:59
I might understand CPanel is just helping you to monitor Mysql activity and those I have
seen from clicking mysql on Cpanel is done by Cpanel and not my mysql.
mysql itself never provide broswer webpage for montioring or admin , Right ?
seen from clicking mysql on Cpanel is done by Cpanel and not my mysql.
mysql itself never provide broswer webpage for montioring or admin , Right ?
Author: duncanb7 replied at 2024-08-04 00:14:22
But why my my.cnf is empty if the mysql software is installed on my server and not specfiy port 3306 ?
Expert: Dave Baldwin replied at 2024-08-04 00:08:04
No, MySQL is separate from Cpanel. If 'mysqld' is running and listening on port 3306, then MySQL is running. The fact that Cpanel expired should not have anything to do with the MySQL installation. Cpanel may have provided an easy admin interface but it does not control the program. You just have to do some reading and use one of the other methods (like I suggested above) for controlling MySQL databases.
Here's one option that you can use on the command line thru SSH: http://dev.mysql.com/doc/refman/5.6/en/mysql.html
Here's one option that you can use on the command line thru SSH: http://dev.mysql.com/doc/refman/5.6/en/mysql.html
Author: duncanb7 replied at 2024-08-03 23:19:25
Dear DaveBaldwin,
sorry about that.Actually, I may understand what you said.
Please point out my following statement and its mistake
Becoz in the past, we used mysql under Cpanel license, and the mysql software
is not installed on my server and the mysql software is installed at CPanel server, Right ?
Now I expired my Cpanel License so whatever I do I cannot access standalone mysql again
since no Cpanel license and the mysql software is not installed on my server.
So what I need to do is that install mysql directly from http://dev.mysql.com/downloads/
on my VPS server and then I can use mysql directly stored at my server without
any license
If all is right, I will close this thread soon
Please advise
Duncan
sorry about that.Actually, I may understand what you said.
Please point out my following statement and its mistake
Becoz in the past, we used mysql under Cpanel license, and the mysql software
is not installed on my server and the mysql software is installed at CPanel server, Right ?
Now I expired my Cpanel License so whatever I do I cannot access standalone mysql again
since no Cpanel license and the mysql software is not installed on my server.
So what I need to do is that install mysql directly from http://dev.mysql.com/downloads/
on my VPS server and then I can use mysql directly stored at my server without
any license
If all is right, I will close this thread soon
Please advise
Duncan
Author: duncanb7 replied at 2024-08-03 11:15:29
please just go to my question thread again.
I have root access and all right for my server
Duncan
I have root access and all right for my server
Duncan
Expert: Dave Baldwin replied at 2024-08-03 10:49:47
I have no idea what you need to do. I only know that you can not access MySQL directly thru your browser which was your original question. That article you linked above shows how to use your MySQL ODBC connector thru SSH. If you have SSH access to the command line on the server, you can use the 'mysql' monitor program if you know the username and password.
Author: duncanb7 replied at 2024-08-03 10:40:14
How to check what version of my mmsql is ?
I need to re-install it, right ?
Just want to record all my users come to my website through my login
php login page with their informtion for registration and I just record all
to my mysql server database
my mysql server is same my domain name VPS server
I need to re-install it, right ?
Just want to record all my users come to my website through my login
php login page with their informtion for registration and I just record all
to my mysql server database
my mysql server is same my domain name VPS server
Accepted Solution
Expert: Dave Baldwin replied at 2024-08-03 10:35:08
500 points EXCELLENT
No browser has the correct protocols to access a MySQL server. You need a different program that does like the 'mysql' monitor program, MySQL Workbench, phpMyAdmin if it is still running, or something like Toad. You will not be able to do it with just a browser.
