Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    Web Hosting


Advertisements:




SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







Mysql Users


How can see mysql users and how can change password for a user.

For example www_user (mysql user) in shell access?


View Complete Thread with Replies

Sponsored Links:

Related Forum Messages:
Users Cannot Connect To MySQL Via Phpmyadmin
It seems I am having issues with WHM/CPanel. I cannot connect to mysql via phpmyadmin through WHM as a root and get this error

#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)

All users get the same error when they try to access mysql from cpanel. The access seems to be only for valid for 192.168.1.%

Would allowing access to localhost will help and how can I do that for all users?

View Replies!   View Related
Limit Concurrent Users In MySQL
I try to search and not found the solutions to limit concurrent of db users to connect to MySQL in same time for example:

Limit user root to connect to MySQL maximum 5 connections in same time

There have max_connections setting but it limit for all users in all connection to MySQL.

But I found that in version 4.1.x there have max_connections property in user table (Users and global privileges) of mysql database, this setting is limit connection in 60 minutes.

I would like to know if there any setting or code modify for this solution that I want.

View Replies!   View Related
Users Cannot Connect To Remote MySQL Server
I have a few users that have a hosting account with me and are trying to connect to their own MySQL servers elsewhere. Both said that they are able to connect to the MySQL server with other hosting accounts but not the ones hosted with me. I asked if they had setup permissions to allow remote connections from my server and they confirmed that they did.

What am I missing? Do I need to configure my firewall somehow? I figured the connection is just using port 80 since it's from an PHP script right?

View Replies!   View Related
Preventing Users From Connecting To Other Users Database
On my server, users can connect to any database as long as they have the database user and password. This makes it easier to hack any database on the server.
What I want to do is to make the users can only connect to their own databases and not other's.

I tried changing the localhost ip address but it didn't work ( I assume I didn't do it the right way)

View Replies!   View Related
Installed MySQL In /usr/local/mysql But Error In /var/lib/mysql
I installed the MySQL binary packages in /usr/local/mysql/ after removing the MySQL RPM package. MySQL is functioning when I executed /usr/local/mysql/bin/safe_mysqld. I reinstalled MySQL before I installed PHP. When I used a PHP script to access a MySQL database, it outputs an error:

Code:
Warning: mysqli::mysqli() [function.mysqli-mysqli]: (HY000/2002): can't connect to local mysql server through socket /var/lib/mysql/mysql.sock in index.php on line 2
However, I installed MySQL in /usr/local/mysql, not in /var/lib/mysql. How do I fix MySQL?

View Replies!   View Related
I Moved Mysql From /var To /backup/mysql, Mysql Is No Longer Working
Since my /var partition is full, so I moved /var/lib/mysql to /backup/mysql/.

Seems all the files are copied and I changed my.cnf reboot mysql, but all the web sites using db is not working anymore..

View Replies!   View Related
Unprivileged Users
I have a few system administrators having full access to the Windows 2003 servers. I fear some of them might be messing up with the server like opening websites on the server or downloading files on the server. I want to create unprivileged users to login to the server so that they can do the basic tasks like reading the log files etc. Can anybody give me the steps for the same?

View Replies!   View Related
SFTP Users
we have a WHM account... we have different accounts on that...and for each account, there are add-on domains underneath that. (i hope you know what i mean)

and we set it up to use only SFTP to connect to server. no FTP.

after we have set it up that way, it seems that we can only connect to SFTP using 1 user/pass for each account... that is the same user/pass we use for Cpanel of each account.

say, i have Account A... under Account A, i have addon domains: A1.com, A2.com, A3.com...
setting SFTP only on that server, all those addon domains of Account A, can only use 1 user/pass to login to SFTP which is the cpanel access also of Account A.

question is.... is this behavior correct??

how can we create a different user for each add-on domain?

View Replies!   View Related
Ssh For Users
im on a vps and enabled ssh to other accounts but how do i know whats the loginid n password for it?

View Replies!   View Related
Online Users ...
I hope this is in the correct section. Secondly, here is my issue that I am hoping someone can help with. I run a fairly successful video streaming site with several thousand members, and several thousand videos. I am trying to determine how many users I have online at any given time. Does anyone know of a piece of software/code out there that can provide me with this information in real time?

View Replies!   View Related
New Users And Subdomain
I am a server admin.

Recently, when I set up new user account, there's something strange in FTP.. ( Please check the image for detail )

Besides, all the new set up subdomain cannot use (no matter new or old user) and 404 error occur.

View Replies!   View Related
MidPulse Users
Does anyone have an experience with this host? In my search I found several favorable comments. I've been collecting different hosts names to consider from those of you kind enough to post them on your signatures. I'm with A Small Orange and am looking for a backup host, or will change the DNS to the backup if they are better.

Others I am considering are Aspire and Known Host. I'll need a shared plan. My site is anywhere from 350 to 450MB's. I try to get twice the space I need because I can have a spike here and there since clients are always downloading my voice files for their projects.

View Replies!   View Related
LiteSpeed Users
Does LiteSpeed webserver provides me bandwidth usage?

Someone told me that he was using 8 mbits connection and after jumping to LiteSpeed, bandwidth usage has decreased to 3 mbits.

View Replies!   View Related
LP - Users Apache
I have installed LP on my system, but I have one problem...

The sites main apache runs well, but I can't get the users apache to start.

The two should be run from different ports?

View Replies!   View Related
My Users Said His IP Is Blocked
My user said he can not view his site from his IP address. His friend from the same ISP also canot access the site.

But i can access from my ISP. So I think probably his IP address has been baned. Therefore, how can I check that? and how can i make his IP range available back?

View Replies!   View Related
Blurstorm Users
Does anybody have a working Blurstorm number? I've tried 850-445-6937 which I found on the internet, but no answer.

Long story short. Signed up to host my website. Credit card charged and approved, but I never received a user name/password confirmation. I'm not able to log on to anything. It has been 4 months and they charge my cc every month which I dispute with the cc company. I can't cancel the web account. My next step is to cancel my credit card.

I have emailed 4 times, left messages at the above number, talked with the chat line. No response. This company is a scam.

Number one rule in chosing a host company, always make sure they have a working customer service number (call it and talk with someone).

View Replies!   View Related
Centos 5, Any Users
Anyone started using Centos 5? Any feedback so far? I am thinking of using Directadmin on Centos 5......

View Replies!   View Related
Users Too Quick To Judge
I find it worrying when new or relatively new users post "[XYZ]VPS PROVIDER IS A SCAM" or "[XYZ]VPS ROBBED ME" in a topic because they didn't get the instant ticket response or fast enough setup time on their $10 VPS..

I'm planning on setting up a budget UK based VPS service myself some time soon, and users would do well to remember that a lot of hard work goes in to the management and set up of such providers. This kind of negative publicity can not be taken back once posted. A quick google search will throw this kind of a post up and cause irrepairable and often, completely unnecessary harm to a business..

View Replies!   View Related
Pervent Users To Something In .htaccess
I dont like users can run following code him .htaccess. How can do it?

AddHandler cgi-script .cgi
AddHandler cgi-script .pl
Options +FollowSymLinks
Options +FollowSymLinks

View Replies!   View Related
Users Password Hacked
In my linux vps (cpanel based) hackers have hacked the password of the user ( website owner ) and he have uploaded some hack files(PHP) through FTP. Sometimes the hacker uploads perl/CGI scripts and sends spam mails .This happens frequently in server. How the hacker gets the users password? How can i prevent my users and server from this security issue?

View Replies!   View Related
Limit Users In PureFTP
Is there any option to limit users only to upload (No other permissions like permission change, directory access etc, only upload) in FTP.. I am using PureFTP..

I have seen options to do it in ProFTP, like below,

<Limit APPE MKD XMKD READ DIRS>
AllowUser username1
AllowUser username2
</Limit>

Is there any option to set in PureFTP ?

View Replies!   View Related
HostDime VPS Users
I've searched around these forums (VPS specifically) and cannot find any recent "reviews" or opinions on HostDime's VPS offerings.

Anyone using them? They seem to have the most bang/buck and I'd like to get a more recent review opinion on them.

View Replies!   View Related
Not Needed Users In Cpanel
I'm running a CPanel server and wondering which of these users are safe to remove and whats the best way to do that?


Code:
bin:x:1:1:bin:/bin:/sbin/nologin
daemon:x:2:2:daemon:/sbin:/sbin/nologin
adm:x:3:4:adm:/var/adm:/sbin/nologin
lp:x:4:7:lp:/var/spool/lpd:/sbin/nologin
sync:x:5:0:sync:/sbin:/bin/sync
shutdown:x:6:0:shutdown:/sbin:/sbin/shutdown
halt:x:7:0:halt:/sbin:/sbin/halt
mail:x:8:12:mail:/var/spool/mail:/sbin/nologin
uucp:x:10:14:uucp:/var/spool/uucp:/sbin/nologin
operator:x:11:0:operator:/root:/sbin/nologin
games:x:12:100:games:/usr/games:/sbin/nologin
gopher:x:13:30:gopher:/var/gopher:/sbin/nologin
ftp:x:14:50:FTP User:/var/ftp:/sbin/nologin
nobody:x:99:99:Nobody:/:/sbin/nologin
avahi-autoipd:x:499:499:avahi-autoipd:/var/lib/avahi-autoipd:/sbin/nologin
vcsa:x:69:69:virtual console memory owner:/dev:/sbin/nologin
ntp:x:38:38::/etc/ntp:/sbin/nologin
dbus:x:81:81:System message bus:/:/sbin/nologin
polkituser:x:87:87:PolicyKit:/:/sbin/nologin
nscd:x:28:28:NSCD Daemon:/:/sbin/nologin
rpcuser:x:29:29:RPC Service User:/var/lib/nfs:/sbin/nologin
nfsnobody:x:65534:498:Anonymous NFS User:/var/lib/nfs:/sbin/nologin
tcpdump:x:72:72::/:/sbin/nologin
avahi:x:498:497:avahi-daemon:/var/run/avahi-daemon:/sbin/nologin
mailnull:x:47:47::/var/spool/mqueue:/sbin/nologin
smmsp:x:51:51::/var/spool/mqueue:/sbin/nologin
sshd:x:74:74:Privilege-separated SSH:/var/empty/sshd:/sbin/nologin
torrent:x:497:496:BitTorrent Seed/Tracker:/var/lib/bittorrent:/sbin/nologin
haldaemon:x:68:68:HAL daemon:/:/sbin/nologin
rpc:x:32:32:Rpcbind Daemon:/var/lib/rpcbind:/sbin/nologin

View Replies!   View Related
Detecting Proxy Users
We are starting a website in .Net for this i want to block Proxy users who using TOR , Squid , IP Hide software users etc...... for this what we need at programing level & Software , Hardware firewalls & Intrusion Detections & Intrusion Preventions will help us in prevent proxy users.

View Replies!   View Related
How Can I Compare If There Are The Same Users In Two Servers
i want to move two servers into a new one,

and i need to prevent there are the same user name in the previous two servers,

so,i want to ask if any way that i can compare if there are the same users in two servers?

View Replies!   View Related
Quota All Users :: Unlimited
i have new vps server..

I added some new user to my server but when i went to List Accounts i found all users with unlimited Quota, i don't why? i already have Packages with specific quote for each one, even, if i made it Options Manually i have the same problem.

i made a reseller and from that reseller i added user with the same problem

if i loge in the cpenal for one user i have this message in the Disk Space Usage

Serious problem while fetching quota data (quota): Illegal seek (0) / MB

View Replies!   View Related
Files Not Downloading To Users
I run a download website boasting many files (entirely legal, non-pornographic), the sizes of which range from 100KB to 500MB. Some users of the site seem to be complaining of the files not downloading and or being truncated (i.e: it says it has been downloaded even though it has not been fully downloaded.)

Here is one reply I received:

"No specific massage appears, only sign the download is complete and infact it is not. About 7 mega down loaded instead of 79 mega. I use fire fox browser and ADSL internet line speed 512"

All the files however do seem to download perfectly on my computer, though I have a good 8mb line, which leads me to believe it may be something to do with a timeout setting?

View Replies!   View Related
Redirect All Users Except Me With Htaccess
I'm going to be doing some upgrades on my site and I want to redirect all users to a different page while I do the upgrades but I need to allow my self too have access.

I have done this before with a htaccess rule, but I can't remember what it was and can't seem to find it anywhere.

View Replies!   View Related
Cpanel Users Limit?
I'm in the process of taking a mid range dedicated server with cpanel. I was just wondering what sort of limit cpanel has with the number of users?

For example

10,000 very small websites using sub domains
1000 average sites with top level domains?

Or is cpanel limit not an issue and it's more down to what the server can handle in terms of it's usage?

View Replies!   View Related
Users With Root Access
How can view all users have root access in system?

View Replies!   View Related
Enabling Crontab For Users
I noticed on my new servers users doesnt have crontab permission.On my first server they have access.So what i need to do to enable users crontab permission automaticly on new servers?I have whm/cpanel there but it seems there is nothing about it there.

View Replies!   View Related
Users Cannot Receive Email
my server is linux and plesk.

SMTP Server (QMail) is stoped in PLESK >> Server >> Service Managment and I cannot start from there.

my customers cannot send/receive their emails, I contacted with our data center to solve this problem for me and they said because the CalmAV was disabled we have this problem, we start the CalamAV but we have this problem yet!

we can sent mail from server but we don't receive any mail.

View Replies!   View Related
SSH Accounts For Users
I have a web server on my dedicated server with several web sites owned by a friend and myself. I am now wanting to setup a gameserver on the same box and will need to give someone I don't know or trust ssh access so that they can kill the gameserver and/or re-execute it as well as modify the configuration files.

How can I go about accomplishing this?

View Replies!   View Related
Stuck On Creating Users
I currently own a dedicated server with direct admin.

Now I want to create a user account for someone else to upload stuff to the server via cuteftp or a program like. that.

But now I can't create another account with the same domain.

Is there anyway around this or another way to do this?

View Replies!   View Related
Any Primary VPS Users
Anyone using this for VPS? Good or Bad?

View Replies!   View Related
How Many Simultaneous Users On A Hostserver
how many simultaneous users on the 2 hostservers below can .

Here are some spec from 2 hostservers.

Processor Pentium 4 2.4Ghz
DDR Memory 1024mb
Hard Drive 80gb SATA

and here is the second one .

Intel Xeon 3040 Dual Core 1.86GHz Processor
2 GB 667MHz ECC RAM
Dual Gigabit Ethernet NIC
2 x 160GB SATA2 Western Digital disks

if you now a better one please tell and give the spec from the server and the number of simultaneous users it can handle.

And lets say fore the simultaneous users that they are on a forum.

View Replies!   View Related
Locking Users In Their Homedir
a way to lock users in their directory. E.g. if I host a domain mydomain.com, I need that the owner of this domain can access (read, write, execute via ssh) only the folder www/mydomain.com and nothing else. The solution does not to be a ultrasecure one.

1] adjusting privileges (e.g. deny execute on dirs for the "others") seems a sure way to make the server unfunctional

2] rbash - when I set shell to rbash for a test user, the user can no longer connect to server through winscp

View Replies!   View Related
Some Users Can't Access My Sites
I have several users that can't access my sites, they are all from different areas of the world, most are on PC's with WinXP and one is on a MAC. I've had them do all the normal stuff..clean cookies, cache etc all with no luck.

I have a dual processor server running Red Hat 7.3 i686. I do have KISS firewall running.

If I stop the firewall, they can get in, but I can also bring it back up and then for several hours they can still connect, but at some point, they stop being able to.

I currently have no ip's blocked. See below:
BLOCK_LIST=" "
TCP_IN="20 21 25 53 80 110 143 443 995 2082:2083 2086:2087 2095:2096 3306 8443 10000 19638 22 26 37 43 873 993"
TCP_OUT="21 22 25 37 43 53 80 443 873 2089 55000"
UDP_IN="53"
UDP_OUT="53"
TCP_IN_TRUSTED="22"
TRUSTED_IPS="0.0.0.0/0"
SERVER_IPS="0.0.0.0/0"

Nothing that I know of changed, it just started about a week ago.

View Replies!   View Related
AOL Users Can Not See Website
We have a small Hosting reseller account at eNom. We have a new customer that moved his website from another hosting company to ours. The website is on a shared IP. Enom also uses a internal IP for internal use associated to the domain.

The problem we have is that AOL users can not see the website. As far as we can tell no other ISP's are having this problem. Everyone can see it except AOL users.

When AOL users go to the site they get "Page can not be found". After several calls to enom support and them triple checking the DNS we still have the problem.

Of course I have tried about 15 different phone numbers to AOL and I get the same automated service that wants an account name or number. Without it they won't let me talk to a real person.

Can anyone offer some suggestions before we loose a new customer?

The domain is [url]. They sell Hot Sauce..

View Replies!   View Related
Best Setting X Spamassasin Under Users Cpanel
What is best settings for spamassasin under cpanel?

How to change default *SPAM* in **MAY BE SPAM**?

View Replies!   View Related
Webmin Add FTP Users
with webmin can I use it to add FTP users to say pure ftpd? and does it work with lighttpd? If I'm thinking about it right webmin just allows us to control the service and modify the configuration files right?

View Replies!   View Related
How Many Users Will My Host/site Be Able To Support
I know this sounds a difficult question, but any rough answer is better than none. I am sure there are rough expectations.

Will it be 10's, 100's, 1,000's, 10,000's etc.

I am looking at a dedicated server Intel Pentium Dual Core 2.0GHz, 1GB memory with network speed of 100mb (with gigabyte burst whatever that means).

[url]- bronze package - if anyone is interested)

I will run one site only. The site has very heavy database usage and normal page views with average images.

Video / most photos are hosted and delivered with a seperate, top-quality CDN.

Your answer might be... "You should get about 1000 surfing, using database etc. before you notice a slow down" etc.

I suppose the thing is.. at what stage would I need a second dedicated server / package upgrade / what will this server get me?

View Replies!   View Related
New Webserver How To Transfer Ftp Users
I had to rebuild out web/ftp box so I built a new one. Now how do I transfer all the ftp users to the new system without change of their passwords?

I am able to trasnfer their directories and i added a line to the /etc/passwd of the new server but it fails.

View Replies!   View Related
UK Users Unable To Connect To One Of My Websites
I've been getting a lot of complaints today on my forum that users cannot view their websites which are subdomains on a seperate domain that I own. It makes no sense why they would have access to the forums which is on the same dedicated server, using the same IP, and with the same nameservers as the site they cannot access. This issue started last night out of nowhere.

Where should I even start looking? It appears to only be with overseas users since none of the US and Canadian users have any issues with either domains or their subdomains.

View Replies!   View Related
Running Web Applications For Many Users....what To Do
I am running an application for which users pay a recurring monthly fee to use.

However, I am not familiar with what kind of hosting and layout i should approach.

Should I just purchase a deicated box from say FDC, and put 5~10 users on it?

Or should I get small vps for each user.

View Replies!   View Related
Users With Old SSL Certificates Cached
We renewed our SSL certificate about two weeks before it expired, and pushed the new one to our servers.

All has worked well, but a very small percentage of users are complaining that they're seeing errors that the certificate is expired.

Is there some browser or something that would cache the old certificate client-side even past its expiry?

View Replies!   View Related
Any Multple Web Host Users
I have medialayer but I still have a contract with ICDSoft (love them too) I've been waiting for the ICDSoft contract to expire later this year and move that website over to medialayer but it occurred to me, why. I get a gig of storage with ICDSoft and I'm using a lot of that. I may blow my quota on medialayer if I move that site over.

Just seems odd for me to have only a handful of sites but yet have two web hosting companies. I may have gone completely over to ICDSoft, but my MovableType blogs don't seem to work as seamlessly on ICDSoft. Also MediaLayer seems to have faster servers which is great on one site that hosts a lot of images.

View Replies!   View Related
Imhosted Vs GNAX - Users Can't Get To Site
I have a site hosted with Imhosted.

6 days ago, three users, one from Denmark, one from the UK and one from California - all reported connectivity trouble. I asked for tracert's from all three.

Two of them fail at 209.51.131.250 ( the California and Denmark one ) and one fails at 209.51.131.234

Both are GNAX servers.

I contacted Imhosted - and for 6 days they have ducked, dived, denied, and given me totally inappropriate stock replies ( such as asking me to check my IP address - when the actual affected IP addresses have already been supplied numerous times). They tried to fob me off saying it was an ISP issue ( two continents, at exactly the same time - yeah, right )

Imhosted have SAID, on two occasions, that they've contacted GNAX to have them fix the issue. So far, the problem remains for all three users.

Fortunately, we have a dedicated server of our own already, and we will be moving to it in the next few weeks. But meanwhile - what the hell can I do to rattle some sense into Imhosted and/or GNAX to get these poor guys back onto the site?

I've had three years of hell with Imhosted. Useless support, dreadful performance, unusable email, PHP and SQL issues - all in all, a dreadful experience.

View Replies!   View Related
VPS Ram Vs Number Of Users
I will generally have around 1-70 people browsing my forums at one time. I would like to know if 128mb of ram would be good enough for average performance?

View Replies!   View Related
Hosting / Number Of Concurrent Users
I am planning to set up a forum. What kind of server do I need? I am expecting to
have

- 40-50 concurrent users

Do I need a dedicated server (2 GB) - which would cost me about - 350$ per month - or is it

possible to find a cheaper solution?

View Replies!   View Related
Possible SSH Login For Unprivileged Users
I disabled ssh for my client in linux-cpanel server but I receive this alert from our firewall :

SSH login alert for user volcan
Time: Sun May 4 06:17:53 2008
IP: 89.165.68.116 (Unknown)
Account: volcan
Method: password authentication

volcan hacked and all index files modified .

It seem user can use ssh with script .

View Replies!   View Related
[Security Alert] - WHMCS Users
this is not a WHMCS vulnerability, & you are most likely not affected if you have used the Further Security Tutorials, given by WHMCS.

1.) What has happened?

A professional hacker, signs up as a client, & adds a shell script to your attachments/downloads folder.
He gains complete access to your WHMCS admin, & changes your paypal & other gateway emails/accounts, to his emails/accounts.

2.) What to do?
Check your attachments/downloads folders, for any such scripts.
Use - [url]Furthur_Security_Steps to secure it.

Go to Payment Gateways, & check if the accounts are yours.

3.) How do I know so much about this?
Our installation, was also hacked. But, this hacker made a mistake.
He used his email account password, for signing up. I could get into his email, & see who has been hacked. I could also get into his PayPal & Egold, & refund all payments intended to go to LaceHost (me). I saw other host's payments too.

4.) Hacker has changed his modus operandi.
He now changes the paypal, to some other host's paypal, instead of his.
He also deleted tables from your database, may create a new administrator account, may modify other accounts, add affiliate commission etc.

5.) For more information on this hacker,
Add me on IM - lacehost [dot] live1 [at] yahoo [dot] com

6.) How many have been hacked?
According to what I saw in his PayPal, & his email, atleast 15 hosts have been hacked.

If your paypal has been changed to some other host's paypal, please do not blame them for hacking, we really do not need an inter-industry war here

View Replies!   View Related
How Do Facebook, MySpace, Etc Serve So Many Users
when I type in www.facebook.com or www.myspace.com I'm taken to the main page but millions of people do the same thing every day.

I have basic understanding of DNS but only for single servers and small websites. I don't know how these organizations link of the necessary servers so that their website is available to all.

View Replies!   View Related
Copyright 2005-08 www.BigResource.com, All rights reserved