473,396 Members | 1,921 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

need help on USERs of MySQL

18
dear frens,

Can u tell me the command to know the no. of users created for a single database?

like if i create a user test for database "sample", is there any command to know whether it is created. Show tables will show all the tables in that database, is there any command for users of that kind?????

thank in advance
sarma
Sep 7 '06 #1
3 1276
ronverdonk
4,258 Expert 4TB
Why do you post this question in 2 threads??? The answer won't get any quicker.

Ronald :cool:
Sep 7 '06 #2
dear frens,

Can u tell me the command to know the no. of users created for a single database?

like if i create a user test for database "sample", is there any command to know whether it is created. Show tables will show all the tables in that database, is there any command for users of that kind?????

thank in advance
sarma
Is that in SQL server or in ORACLE? you posted a question in sql forums and looks like the question is about oracle. which database is that?

cheers,
satya.
Sep 7 '06 #3
sarma
18
I am using MySQL as my database....... in that i want to know command to know how many users are created on a particular database...


sarma
Sep 8 '06 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: danaf | last post by:
Dear all, (1)Is it possible to host PHP-based Web Portal + MySQL Database (e.g. PHPNuke) on MS Windows System? If yes which server software I need? (2)Compare PHP over JSP/ASP/CGI in...
3
by: new_GUY | last post by:
I have a HUGE project (at least for me) and need some guidance. I am trying to create a database for a local university movie club that allows users to input there basic personal information...
0
by: Michael Iatauro | last post by:
I've been having a little trouble creating users cross-platform. I have a little script that works just fine on Solaris 8 using this command: eval "/path/to/mysql --user=root --password=*****...
0
by: root | last post by:
hi there, I've tried to install mysql-3.23.55.tar.gz but failed. Firstly, I've created directory /home/users/mysql and add group for mysql. Those are the command that I've used previously: ...
0
by: Jonathan Fowler | last post by:
I know this is the mysql mailing list but I have tried the Fuse mailing list and no one will help well what im wanting to know is how could I get more avatars show in a room like I already have it...
0
by: Dan McCoy | last post by:
I'm new to MYSQL, having just finished my website. I have 1 thing left to try and do to make the site experiance as seemless as possable, but to do it I figure I need to do some sort of mysql...
1
by: jistanidiot | last post by:
We're in the middle of upgrading from MySQL 3.23 to MySQL4.1. I'm trying to import all of the info in the mysql database (ya know the db that keeps track of all the users and what they can and...
0
by: Patrox | last post by:
hi ! in mysql doc it is stated that : "MySQL supports local transactions (within a given client connection) " ref : http://dev.mysql.com/doc/refman/5.1/en/transactional-commands.html but what...
1
by: rija | last post by:
Hi folks, I need help regarding date and time comparison in PHP and MySQL My website is hosted in the USA (GMT - 8) And It is managed in Madagascar (GMT + 3) Want to consider DATE in Madagascar...
1
by: soft_devjava | last post by:
my environment: =========================== -php ver 5.2.0 -mysql 5 -windows xp -apache 2 -all of these are on the same machine my code: ==========================
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.