Содержание

How to completely uninstall MySQL?
How to Install/Uninstall/Execute MySQL as Windows Service
Install MySQL as windows service
Start MySQL as windows service
Remove/Uninstall MySQL as windows service
Share this:
About Lokesh Gupta
Feedback, Discussion and Comments

How to completely uninstall MySQL?

how to uninstall mysql cleanly?

* Moved from Health & band

***Modified the title from Uninstal MySQL***

Thank you for writing to Microsoft Community Forums.

Which version of Windows is installed on your device?

Refer the article ‘ Which Windows operating system am I running ’ to provide the details.

I suggest you to follow the steps mentioned below to uninstall MySQL from the device.

Step 1

Uninstall MySQL from Control Panel. To do so,

Go to Control Panel >Programs and Features > Select MySQL > Click on Uninstall.

After you have uninstalled MySQL through Add/Remove programs, you now need to remove the existing database information which includes your actual data. If you need any of that data, be sure to back it up. Next you can delete the data directory.

Step 2

Run Command Prompt as Administrator and execute the following command to stop and remove MySQL service.

Net stop MySQL

Sc delete MySQL

Step 3

Click on Start, type in Show hidden files and folders.

Select the View tab and select Show hidden files and folders.

Now explore the following locations and delete following folders.

C:\Program Files\MySQL

C:\Program Files (x86)\MySQL

C:\ProgramData\MySQL

And if exists, delete the folder from the location.

C:\Users\[User-Name]\AppData\Roaming\MySQL

Restart your device and check the status.

Get back to us for further assistance on this issue. We will be happy to help you.

How to Install/Uninstall/Execute MySQL as Windows Service

On Windows, It is always recommended to install and run MySQL as a Windows service, so that MySQL starts and stops automatically when Windows starts and shutdown. Also, it can be managed using the services section of control panel. A MySQL installed as a service can also be controlled from the command line using NET commands (command to start a service), or with the graphical Services utility. Generally, to install MySQL as a Windows service you should be logged in using an account that has administrator rights.

This post is in continuation to series about learning MySQL concepts. In previous post, we learned about MySQL Configuration and Command Line Options. In this post, I will talk about installing and using MySQL as a windows service.

Install MySQL as windows service

To install MySQL as a Windows service manually, execute this in a command line shell, e.g.

Читайте также: Mac os todo list

Where “MySQLXY” is any service name you want to give to MySQL windows service. And “defaults-file” is the location of configuration file which you want to use for providing startup configuration parameters.

Start MySQL as windows service

To Start the installed windows service from command prompt, execute this command e.g.

Above command will start the service and as a result, MySQL will be running into your system.

Install as a MySQL Windows service manually

Remove/Uninstall MySQL as windows service

To uninstall the installed windows service from command prompt, execute this command e.g.

Above command will delete the windows service. It will not uninstall the MySQL from your system, only windows service gets deleted. NO HARM !!

Happy Learning !!

About Lokesh Gupta

A family guy with fun loving nature. Love computers, programming and solving everyday problems. Find me on Facebook and Twitter.

Feedback, Discussion and Comments

send me your mail id i’ll send the project..

December 13, 2013

Hi Guptha,
My task is “list of all users who are currently logged into my project”This should pop up as new page on click of a button with name “logged-in users”. The table should list following columns
1] First Name
2] Last Name
3] user-id
4] email
5] contact number
You already send the code but it is not working i’ll send my files could you please check and tell me how to do this ?
UserPrincipal.java file name
public final class UserPrincipal //implements Serializable, HttpSessionBindingListener <
<

/**
* User Id.
*/
private Integer userId;

/**
* First Name.
*/
private String firstName;

/**
* Last Name.
*/
private String lastName;

/**
* User Email.
*/
private String userEmail;

/**
* User Email Alias.
*/
private String userEmailAlias;

/**
* Role Code.
*/
private Integer roleCode;

/**
* Change Password Flag.
*/
private Boolean changePasswordFlag;

/**
* Company Name.
*/
String companyName;

/**
* successfull login date time.
*/
private Date lastSuccessfulLoginTime;

/**
* UserPrincipal Constructor.
*
* @param userId user id
* @param firstName first name
* @param lastName last name
* @param userEmail user email
* @param userEmailAlias user email alias
* @param roleCode role code
* @param changePasswordFlag change password flag
* @param companyName user company name
*/
public UserPrincipal(Integer userId, String firstName, String lastName,
String userEmail, String userEmailAlias, Integer roleCode,
Boolean changePasswordFlag, String companyName, Date lastLoginDate) <
super();
this.userId = userId;
this.firstName = firstName;
this.lastName = lastName;
this.userEmail = userEmail;
this.userEmailAlias = userEmailAlias;
this.roleCode = roleCode;
this.changePasswordFlag = changePasswordFlag;
this.companyName = companyName;
this.lastSuccessfulLoginTime = lastLoginDate;
>

/**
*
* @return user id
*/
public Integer getUserId() <
return userId;
>

/**
*
* @return first name
*/
public String getFirstName() <
return firstName;
>

/**
*
* @return last name
*/
public String getLastName() <
return lastName;
>

/**
*
* @return user email
*/
public String getUserEmail() <
return userEmail;
>

/**
*
* @return user email alias
*/
public String getUserEmailAlias() <
return userEmailAlias;
>

/**
*
* @return role code
*/
public Integer getRoleCode() <
return roleCode;
>

/**
* @return the changePasswordFlag
*/
public Boolean getChangePasswordFlag() <
return changePasswordFlag;
>

/**
* @return the companyName
*/
public String getCompanyName() <
return companyName;
>

/**
* @return the lastSuccessfulLoginTime
*/
public Date getLastSuccessfulLoginTime() <
return lastSuccessfulLoginTime;
>

/**
* @param lastSuccessfulLoginTime the lastSuccessfulLoginTime to set
*/
public void setLastSuccessfulLoginTime(Date lastSuccessfulLoginTime) <
this.lastSuccessfulLoginTime = lastSuccessfulLoginTime;
>

/**
* This method throw CloneNotSupportedException, whenever anyone try to
* attempt cloning operation.
*
* @see java.lang.Object#clone()
* @return Object
* @throws CloneNotSupportedException clone not supported
*/
@Override
protected Object clone() throws CloneNotSupportedException <
throw new CloneNotSupportedException();
>

/* (non-Javadoc)
* @see javax.servlet.http.HttpSessionBindingListener#valueBound(javax.servlet.http.HttpSessionBindingEvent)
*/
/* @SuppressWarnings(“unchecked”)
@Override
public void valueBound(HttpSessionBindingEvent sessionBindingEvent) <
System.out.println(“in valueBound===================================================================================”);

System.out.println(” added userPrinipal “);
ServletContext appContext = sessionBindingEvent.getSession()
.getServletContext();
Map loggedInUsersMap = new HashMap();

if (appContext.getAttribute(“loggedInUsersMap”) == null) <

appContext.setAttribute(“loggedInUsersMap”, loggedInUsersMap);
> else <
loggedInUsersMap = (Map) appContext
.getAttribute(“loggedInUsersMap”);
>
UserPrincipal userPrincipal = (UserPrincipal) sessionBindingEvent
.getSession().getAttribute(“userPrincipal”);

// add loggedin user into map
if(userPrincipal != null)
loggedInUsersMap.put(userPrincipal.getUserId(), userPrincipal);

(non-Javadoc)
* @see javax.servlet.http.HttpSessionBindingListener#valueUnbound(javax.servlet.http.HttpSessionBindingEvent)

@SuppressWarnings(“unchecked”)
@Override
public void valueUnbound(HttpSessionBindingEvent sessionBindingEvent) <
System.out.println(“in valueUnbound===================================================================================”);

// TODO Auto-generated method stub
System.out.println(” remove userPrinipal “);
ServletContext appContext = sessionBindingEvent.getSession()
.getServletContext();
Map loggedInUsersMap = new HashMap();

if (appContext.getAttribute(“loggedInUsersMap”) == null) <

// add loggedin user into map
if(userPrincipal != null)
loggedInUsersMap.remove(userPrincipal.getUserId());

>
UserController.java:this file specifies the connection form server to UI

// @SuppressWarnings(< “unused”, “unchecked” >)
@RequestMapping(“/getLoggedInUser”)
public @ResponseBody String getUserDetails(HttpServletRequest request,
HttpServletResponse response) throws IOException, ServletException <
//logger.trace(“Entering method”);
// Get the session object
//HttpSession session = null;
//session = request.getSession(false);
JSONObject outerObj = new JSONObject();
JSONArray userArray = new JSONArray();
List userlist = new ArrayList();
userlist.add(new UserPrincipal(1, “gfgf”, “gfgfdg”, “gfgfdg”, “gfgfdg”, 2, false, “gfgfdg”, new Date()));
userlist.add(new UserPrincipal(2, “gfgf”, “gfgfdg”, “gfgfdg”, “gfgfdg”, 2, false, “gfgfdg”, new Date()));
userlist.add(new UserPrincipal(3, “gfgf”, “gfgfdg”, “gfgfdg”, “gfgfdg”, 2, false, “gfgfdg”, new Date()));
userlist.add(new UserPrincipal(4, “gfgf”, “gfgfdg”, “gfgfdg”, “gfgfdg”, 2, false, “gfgfdg”, new Date()));

UserPrincipal user = null;
//JSONObject User = new JSONObject();
for (UserPrincipal user1 :userlist ) <
JSONObject userObj = new JSONObject();
userObj.put(“userId”, user1.getUserId());
userObj.put(“userFirstName”, user1.getFirstName());
userObj.put(“userLastName”, user1.getLastName());
userObj.put(“userEmail”, user1.getUserEmail());
//userObj.put(“userPhone”, user1.getUserPhone());
userObj.put(“userCompanyNname”, user1.getCompanyName());
userArray.add(userObj);

outerObj.put(“Result”, “OK”);
outerObj.put(“Records”, userArray);
outerObj.put(“TotalRecordCount”, userArray.size());

logger.debug(“getUserDetails method”);
return outerObj.toJSONString();
>
and this is my jtable mange.js
var jTable;
function showLoggedInUsers() <

// start of logged in user jTable.
updateBackgroundHeight();
$(“#LoggedInUserTableContainer”).jtable( <
title:’Logged-In Users’,
paging: true, //Enable paging
pageSize: 10, //Set page size
sorting: true, //Enable sorting
//width:700,
defaultSorting: ‘userId ASC’, //Set default sorting
listClass: ‘child-opener-image-column’,
openChildAsAccordion: true,
jqueryuiTheme :true,
recordsLoaded: onRecordsLoaded,
loadingAnimationDelay : 0,
ajaxSettings: <
type: ‘POST’,
dataType: ‘json’
>,
actions: <
listAction: ‘getLoggedInUser’
>, //end of actions

messages : <
noDataAvailable : jQuery.i18n.prop(‘userManagement.jtable.noRecords’),
loadingMessage : “wait..Loading data”
>,

fields: <
userId: <
key: true,
//title: jQuery.i18n.prop(‘userManagement.jtable.lblUserId’),
create: true,
edit: true,
list: false
>,

userFirstName: <
//title: jQuery.i18n.prop(‘userManagement.jtable.lblFirstName’),
create: true,
edit: true,
list: true,
width:’14%’
>,
userLastName: <
//title: jQuery.i18n.prop(‘userManagement.jtable.lblLastName’),
create: true,
edit: true,
list: true,
width:’14%’
>,
userCompanyNname: <
//title: jQuery.i18n.prop(‘userManagement.jtable.lblCompany’),
create: true,
edit: true,
list: true,
width:’11%’
>,
userPhone: <
//title: jQuery.i18n.prop(‘userManagement.jtable.lblPhoneNo’),
create: true,
edit: true,
list: true,
width:’19%’
>,
userEmail: <
//title: jQuery.i18n.prop(‘userManagement.jtable.lblEmail’),
create: true,
edit: true,
list: true,
width:’14%’
>,
>
>);

//end of jtable
//showActionDialog(jTable, “Logged-In Users”);
//showLoader(“Wait. Loading User Data…”);
$(‘#LoggedInUserTableContainer’).jtable(‘load’);
>

December 13, 2013

Send the project in zip.

December 6, 2013

Hi Guptha,
I had a doubt.My doubt is there is one login screen,after login screen there is one user management page.In UM page there is one jtable is displayed.So my question is there is one “logged in users” button in toolbar.In table i already predefined some users with the fields of (First name,Last-name,Company,phone-no).when i click that button i have to show logged in users list.How to do this task in session could you please help me in this…?

December 7, 2013

Just collect all logged in users in a Set in the application scope. Let’s implement HttpSessionBindingListener and add/remove the user from the Set when it’s about to be bound/unbound in the session.

public class User implements HttpSessionBindingListener <

@Override
public void valueBound(HttpSessionBindingEvent event) <
Set logins = (Set ) event.getSession().getServletContext().getAttribute(«logins»);
logins.add(this);
>

@Override
public void valueUnbound(HttpSessionBindingEvent event) <
Set logins = (Set ) event.getSession().getServletContext().getAttribute(«logins»);
logins.remove(this);
>

// @Override equals() and hashCode() as well!

Then, anywhere in your application where you’ve access to the ServletContext, like in a servlet, you can just access the logged-in users as follows:

Set logins = (Set ) getServletContext().getAttribute(«logins»);

December 10, 2013

Thanks for your reply..Thank you so much.

December 1, 2013

Since deleting the service wont uninstall MySQL, can we not manually configure MYSqlXY service to not start when windows start ,so that we need not create service again?